Changing Part of a String in SQL and Updating the Table

Something like this:

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

Sources

• MySql replace command
• Using MySQL, Built-In Functions