Need to replace HTML single-quote entity in MySQL
- by modulaaron
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.