Am I correct in that this query will replace all instances of the text "red" with the text, "blue" in existing posts?
Is this fine or is there a better query to use?
Thanks
Code:
update POST set PAGETEXT = replace(PAGETEXT, ‘red’, ‘blue’);
Thanks
Comment