How to use MySQL REPLACE function

update my_table SET `my_field` = replace(`my_field`, "old_text", "new_text")

Head over for more details to http://www.webmasterworld.com/forum10/8113.htm