Search and replace in MySQL
The following query will be handy if one likes to search and replace a string in a particular column.
update tablename set field = replace(field,'search_for_this','replace_with_this');
An Eternal Quest for Incremental Improvement
The following query will be handy if one likes to search and replace a string in a particular column.
update tablename set field = replace(field,'search_for_this','replace_with_this');