Need to replace HTML single-quote entity in MySQL

Question

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, '&#39;', '\'');

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.

Chad Birch · Accepted Answer · 2010-04-01 23:42:17Z

2

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

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

answered Apr 1, 2010 at 23:42

Chad Birch

75k24 gold badges156 silver badges150 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

modulaaron Over a year ago

That is exactly what I meant - I accidentally excised the missing part. Oops - and thanks!

modulaaron Over a year ago

No, works great. I previously had unintentionally removed the "SET title = " from the statement and did not notice.

Daniel Vassallo Over a year ago

@modulaaron: You may want to mark the answer as accepted, by clicking on the green tick, if it was helpful. And welcome to Stack Overflow :)

Daniel Vassallo · Accepted Answer · 2010-04-01 23:42:32Z

2

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

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

The REPLACE() function works correctly:

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

answered Apr 1, 2010 at 23:42

Daniel Vassallo

346k72 gold badges513 silver badges447 bronze badges

Collectives™ on Stack Overflow

Need to replace HTML single-quote entity in MySQL

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related