MySql – search and replace a string in a column

If we and to search some specific string inside our column data and replace it with other string then we can use replace query of MySql.

Suppose table name is ‘users’ and we want to search city column with a value ‘London’ and replace it with ‘New York’

update users set city = replace(city, 'London', 'New york');