update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');

http://www.mediacollege.com/computer/database/mysql/find-replace.html

remove the square brackets

Find and replace a string

mysql

MySQL