MySql handy commands

Replace field data with another value

UPDATE table_name SET field = replace(field,'string-to-find','string-that-will-replace-it');