I need to do a find and replace mysql statement.
I wrote this statement to replace the odd characters with a single quote in table jos_content and row fulltext.
update jos_content set fulltext = replace(fulltext, 'â¬"', '\'')
I get an error. I have tried finding the html entities for each of the three characters and replacing them but still get an error. Anythoughts?