This little query updates a search string and replaces it with a replace string.

Find and replace query for mysql 

 UPDATE `table_name` SET `field_name` = replace(`field_name`, 'search_term' , 'replace_term' )