How do I do a search and replace in posts when I want the replacement to be an apostrophe or quotation mark?
Normally this is what I would run to replace text:
I need to replace this with an apostrophe:
I need to replace this with a general quotation mark:
How do I do a search and replace in that query so that the NEW TEXT is read as an apostrophe or quotation mark?
Thanks in advance.
Normally this is what I would run to replace text:
Code:
UPDATE post SET pagetext = REPLACE(pagetext,'OLD TEXT','NEW TEXT')
Code:
'
Code:
[COLOR=#323232][FONT=verdana]"[/FONT][/COLOR]
Thanks in advance.
Comment