Dibatalkan

MySQL SQL Query Help - Find & Replace Query

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.

Kemahiran: MySQL, SQL

Lihat lagi: mysql replace character in string, php mysql search and replace, mysql replace, replace special characters in mysql query, sql query to find and replace text in a column, phpmyadmin find and replace url, find and replace url in mysql database, mysql find and replace part of string, transfer data mysql sql server, creating php registration login mysql sql, mysql sql server oracle postgres, mysql sql server replication, mysql sql server db2 oracle, mysql sql file, help find good header letter, mysql sql, mysql sql server oracle db2 postgresql, mysql sql files, vtiger mysql sql server, vb6 mysql sql safe

Tentang Majikan:
( 378 ulasan ) London, United Kingdom

ID Projek: #17539437

25 pekerja bebas membida secara purata $6/jam untuk pekerjaan ini

maxsmith8

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 yo Lagi

$7 USD / jam
(84 Ulasan)
7.0
ravinder246

Hello , i read your project , i can do this i have 10 years experienced in multiple frameworks . i developed multiple work i am expert in mysql ,php you can check my previous work. wordpress- http://www. Lagi

$5 USD / jam
(105 Ulasan)
6.5
phpwebsoft

Hi, Did you try using double quotes SET `description` = REPLACE(`description`, "’", ''') WHERE `description` like "’%"

$8 USD / jam
(98 Ulasan)
6.3
dapu92

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 actual Lagi

$5 USD / jam
(5 Ulasan)
3.5
cplaiasu

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 / jam
(6 Ulasan)
2.7
markninja

Hi, Hope you are doing great. Kindly check: [login to view URL] [login to view URL] [login to view URL] I can complete your project on time and within your budget. I can achieve t Lagi

$8 USD / jam
(1 Ulasan)
2.8
delostyle

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 Lagi

$2 USD / jam
(3 Ulasan)
2.4
ankitbagre2000

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 / jam
(5 Ulasan)
2.2
sfeuh

hi, i am online now, just contact me i will help you. thanks.

$11 USD / jam
(4 Ulasan)
1.8
onestopit71

Hi, Don’t worry as I have 1 review only :) I am highly interested to get this job done. Let’s make it from the start to finish. Do you really care about code? Let make this app enterprise one with best coding sta Lagi

$7 USD / jam
(1 Ulasan)
0.6
alexdanilovua

Hi, dear! If you decide to work with me, I promise I will wonderfully complete your job. I will looking forward to your response.

$11 USD / jam
(0 Ulasan)
0.0
shrishayn03

HIIII WE ARE TEAM FROM PUNE,INDIA WITH ALL TEAM COMPLETED MASTERS DEGREE IN COMPUTER SCIENCE !!! WE HAVE DONE MANY PROJECTS IN TEAM AND WE WILL DO OUR BEST TO COMPLETE YOUR PROJECT IF WE GIVEN A CHANCE

$3 USD / jam
(0 Ulasan)
0.0
psranjana

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 / jam
(0 Ulasan)
0.0
GWebDesk

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, appoin Lagi

$5 USD / jam
(0 Ulasan)
0.0
saniasnain00

Please share more details about the project so we can discuss the deliverables. Visit profile for reference work please.

$6 USD / jam
(0 Ulasan)
0.0
$5 USD / jam
(0 Ulasan)
0.0
$3 USD / jam
(0 Ulasan)
0.0
$5 USD / jam
(0 Ulasan)
0.0
sachchusinghal

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. HT Lagi

$5 USD / jam
(0 Ulasan)
0.0
atiqprogramer

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 / jam
(0 Ulasan)
0.0