Changing Part of a String in SQL and Updating the Table

Posted by Trey on March 02, 2007

Something like this:

update `table_name` set `field_name` = replace(`field_name`, 'text_to_replace', 'new_text')

Sources