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.
1 |
UPDATE table_name SET table_field = REPLACE(table_field, 'value', 'new_value') WHERE my_field LIKE '%value%'; |