Find & Replace a String in MySQL Jan 09, 2011 update `table_name` set `field_name` = replace( `field_name`, 'string_to_find', 'string_to_replace' );