MySQL find and replace string

If you want to search for a string inside a table and replace it with something else you can use the following SQL:

UPDATE `YOUR_TABLE_NAME` SET YOUR_FIELD_NAME = REPLACE(YOUR_FIELD_NAME, 'SEARCH_FOR', 'REPLACE_WITH')