Find and Replace Query
 

Am I correct in that this query will replace all instances of the text "red" with the text, "blue" in existing posts?

Code:
update POST set PAGETEXT = replace(PAGETEXT, ‘red’, ‘blue’);
Is this fine or is there a better query to use?

Thanks