Find Jobs
Hire Freelancers

MySQL SQL Query Help - Find & Replace Query

$2-8 USD / hour

Dibatalkan
Dibuat hampir 6 tahun yang lalu

$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 Proyek: 17539437

Tentang proyek

22 proposal
Proyek remot
Aktif 6 tahun yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan
22 freelancer menawar dengan rata-rata $6 USD/jam untuk pekerjaan ini
Avatar Pengguna
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 dalam 1 hari
4,8 (99 ulasan)
7,1
7,1
Avatar Pengguna
Hi, Did you try using double quotes SET `description` = REPLACE(`description`, "’", ''') WHERE `description` like "’%"
$8 USD dalam 1 hari
5,0 (98 ulasan)
6,3
6,3
Avatar Pengguna
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 dalam 40 hari
4,9 (26 ulasan)
5,1
5,1
Avatar Pengguna
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 dalam 40 hari
5,0 (6 ulasan)
4,3
4,3
Avatar Pengguna
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 dalam 1 hari
5,0 (11 ulasan)
3,9
3,9
Avatar Pengguna
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 dalam 40 hari
5,0 (5 ulasan)
3,5
3,5
Avatar Pengguna
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 dalam 1 hari
5,0 (2 ulasan)
2,4
2,4
Avatar Pengguna
Please share more details about the project so we can discuss the deliverables. Visit profile for reference work please.
$6 USD dalam 40 hari
5,0 (1 ulasan)
2,1
2,1
Avatar Pengguna
hi, i am online now, just contact me i will help you. thanks.
$11 USD dalam 1 hari
5,0 (6 ulasan)
2,2
2,2
Avatar Pengguna
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 dalam 40 hari
5,0 (2 ulasan)
1,0
1,0
Avatar Pengguna
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 dalam 40 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
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 dalam 40 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
$5 USD dalam 40 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
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 dalam 40 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
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 dalam 2 hari
0,0 (0 ulasan)
0,0
0,0

Tentang klien

Bendera UNITED KINGDOM
London, United Kingdom
5,0
449
Memverifikasi Metode pembayaran
Anggota sejak Jul 9, 2012

Verifikasi Klien

Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.