I have a table of articles. As a word editor was used to create the content, I have a whole load of strange diamond boxes with question marks inside where a normal double quote should be.
How can I do a command in mysql to replace all of these with normal double quote chars?
SET content = REPLACE(REPLACE(content,'“','"'),'”','"')
sorry only just spotted the reply! Why do you have to repeat the repace?
sorry spotted 2 different quotes!!
so... did it work when you tested it?
Yes thanks, although I'm having to add a whole load of other chars now!! Going to replace these on entry in future