Replace non standard quotes in table

skyline · December 18, 2011, 3:36pm

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?

r937 · December 19, 2011, 9:47am

UPDATE daTable
   SET content = REPLACE(REPLACE(content,'“','"'),'”','"')

skyline · December 20, 2011, 5:30pm

sorry only just spotted the reply! Why do you have to repeat the repace?

skyline · December 20, 2011, 5:38pm

sorry spotted 2 different quotes!!

r937 · December 20, 2011, 5:41pm

so… did it work when you tested it?

skyline · December 20, 2011, 6:15pm

Yes thanks, although I’m having to add a whole load of other chars now!! Going to replace these on entry in future