Needed to update a string occurring hundreds of times within a MySQL database. This sorted it:

update ee_channel_data set field_id_1 = replace(field_id_1, 'old string', 'new string')