Find Jobs
Hire Freelancers

MySQL SQL Query Help - Find & Replace Query

$2-8 USD / hour

Cancelado
Publicado hace más de 5 años

$2-8 USD / hour

Project Duration: 1 Hour Project Overview When trying to run this query: SET `description` = REPLACE(`description`, '’', ''') WHERE `description` like '’%' We get the following error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''&#39)' at line 1 I want to know why & what the solution is.
ID del proyecto: 17539437

Información sobre el proyecto

22 propuestas
Proyecto remoto
Activo hace 6 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
22 freelancers están ofertando un promedio de $6 USD /hora por este trabajo
Avatar del usuario
Hello there, I am interested and ready to start. I WILL FIC THIS IN 1 HOUR. Please visit our profile and see our project reviews https://www.freelancer.com/u/maxsmith8.html looking forward to hear from you soon. Thanks & Regards, Manish
$7 USD en 1 día
4,8 (99 comentarios)
7,1
7,1
Avatar del usuario
Hi, Did you try using double quotes SET `description` = REPLACE(`description`, "’", ''') WHERE `description` like "’%"
$8 USD en 1 día
5,0 (98 comentarios)
6,3
6,3
Avatar del usuario
Hello Greetings I can Deliver exactly what you want. Need to Discuss more on the chat and also for the budget. Looking forward to your Response. Thanks Regards
$4 USD en 40 días
4,9 (26 comentarios)
5,1
5,1
Avatar del usuario
Hi , I have gone through the job details carefully and I am excited to start working on this project. I am confident that I can exceed your expectations by my quality of delivery. I have an extensive knowledge of Php, Wordpress, MySql, Html5, Css3, Javascript and more. I will be able to contribute to this project by: helping MySQL SQL Query as per your requirement . which will complete the project in time and with all required functionalities. Please let me know of a good time so that we can discuss about the fine points of the projects. Looking forward to build up a long term professional relationship with you. Thanks Rajib
$2 USD en 40 días
5,0 (6 comentarios)
4,3
4,3
Avatar del usuario
Hi, It's either missing UPDATE table_name SET description=... or some escaping issues. I can test that quick if you give me access to phpmyadmin or ssh. Best Regards, Constantin Plaiasu
$5 USD en 1 día
5,0 (11 comentarios)
3,9
3,9
Avatar del usuario
Hello, firstly can you confirm your charset of the database table. If its a backed up or empty table, try setting the charset to utf8 mb4 general/unicode ci ...and see if the problem goes away, The problem is actually &#39; I just looked up ASCII tablet, it translated to a single colon so you can escape it with a \ or use <<entity>><entity> it will solve your problem.
$5 USD en 40 días
5,0 (5 comentarios)
3,5
3,5
Avatar del usuario
I can help with your syntax error and write the correct update statement. Could you please provide details such as the table name and column name you are trying to update?
$7 USD en 1 día
5,0 (2 comentarios)
2,4
2,4
Avatar del usuario
Please share more details about the project so we can discuss the deliverables. Visit profile for reference work please.
$6 USD en 40 días
5,0 (1 comentario)
2,1
2,1
Avatar del usuario
hi, i am online now, just contact me i will help you. thanks.
$11 USD en 1 día
5,0 (6 comentarios)
2,2
2,2
Avatar del usuario
Hi I read your job description and I am able to fix the issue. As per the technical prerequisites I would like to share that we have EXCELLENT RESOURCES to work on following platforms: 1. PHP/MySQL 2. HTML5, Bootstrap, AJAX, W3C, CSS (Responsive Design) 3. Payment gateways API 4. JQuery/NodeJS/AngularJS /React Js 5. PHP frameworks like CAKE PHP, Yii framework, ZEND 6. CMS like Wordpress, Magento and other. 7. Linux and Apache web servers 8. Jason/XML/REST API & Google Maps API. Let me know when we can start.
$5 USD en 40 días
5,0 (2 comentarios)
1,0
1,0
Avatar del usuario
Hello We have 4+ year experience in website development and mobile applications development. We can do your project in your budget and cost. We have expertise in developing e-commerce, ordering applications, appointment booking applications, business applications etc. TECHNICAL SUMMARY IT skills: - Core PHP, PHP with oops concept. - CMS WordPress,WooCommerce, Joomla, OpenCart. - MVC framework CodeIgniter. - RESTful API - HTML, CSS, JavaScript, jQuery, core Please ping me disucss more. Thanks.
$5 USD en 40 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi I have reviewed your requirements for your preconceived project As all your requirements are crystal clear to me so I would like to discuss your project querries in more detail which would let me to quote you the actual cost and suggest you more ideas over it. We'll be providing you with our updated portfolio after you hit up with a reply Regards Fsd solutions
$5 USD en 40 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
$5 USD en 40 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi I am a database administrator. It my daily job to write queries. Today I am free you can contact me for your project.
$3 USD en 40 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
i have quality experience in sql my sql and database i can do for you in a time if u give me a chance
$4 USD en 2 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED KINGDOM
London, United Kingdom
5,0
449
Forma de pago verificada
Miembro desde jul 9, 2012

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.