MySQL replace function – Find and replace values in database with sql

Category : MySQL · by Steven Dobbelaere Jan 12th, 2010

A great piece of sql that can save you a lot of time. The replace sql function finds and replaces values in a database.

Just fill in the table_name, table_field, the value your searching for and with which value you want to replace it with.

UPDATE table_name SET table_field = REPLACE(table_field, 'value', 'new_value') WHERE my_field LIKE '%value%';

1	UPDATE table_name SET table_field = REPLACE(table_field, 'value', 'new_value') WHERE my_field LIKE '%value%';