mysql update replace

You sometimes run into the problem that you want to replace a substring occurring in a column with a different string, without touching the rest of the string. The solution is surprisingly simple, thanks to MySQL


UPDATE table SET field=(REPLACE (field, 'search text', 'replace text'));


using the string function REPLACE, all items in the field column with 'search text' get this substring replaced by 'replace text'. Ideal when writing a script is just too much effort.

quoted (and modified) from: dev.mysql.com