How to replace data in MySQL

MySQL, by Joakim Ling.

This is how you can find a string in a certain field and replace it with another string

mysql> update `table_name` set `field_name` = replace(`field_name`, 'search_string', 'replace_string');

If you need to improve your skills try my linux training guide, read more