MSYQL Find & Replace

To do a simple 'find and replace' in MySQL, use the following command :

update table set field replace(field],'string_to_find','string_to_replace');