REPLACE function in mySql.
MySql database has very simple and easy to use string function REPLACE() that is used to find any string and replace it with new string. This is very useful when we required replacing any content in multiple rows. It performs a case-sensitive match when searching for from_str. It has following syntax.
text_string: The string in which you want to find and replace.
from_string: The string that you want to replace.
to_string: The string that you want after replace.
Update Table set Field = REPLACE(field_name, ‘find string’,’replace string’);
You can read more about MySql functions on mysql function references.