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 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