Need to replace HTML single-quote entity in MySQL

Question

Hi, I currently have the following MySQL statement to replace the HTML entity for a single quote with an actual single quote:

update photo_galleries replace(title, ''', '\'');

This statement returns an error. I have tried adding additional backslashes, but this does not help at all. I want to run this command using pure SQL (no PHP, etc.). Any suggestions are welcome and appreciated. Thanks.

Answer 1

This isn't a valid SQL query, you were probably looking for:

UPDATE photo_galleries
SET title = REPLACE(title, ''', '\'');

Answer 2

Your UPDATE statement is invalid. You may want to try:

UPDATE photo_galleries SET title = REPLACE(title, ''', '\'');

The REPLACE() function works correctly:

SELECT REPLACE('hello='test'', ''', '\'') AS output;
+--------------+
| output       |
+--------------+
| hello='test' | 
+--------------+
1 row in set (0.00 sec)