Replace in MySQL

In case you need to replace a text field of several rows in MySQL there is function REPLACE wich can help you to do so, one example below:

update table set my_field=replace(my_field,'string_to_modify','string_modified') where...

Reference:

https://dev.mysql.com/doc/refman/5.6/en/string-functions.html#function_replace