Chris Miller

Finding a string in a set of MySQL result rows and replacing the text is very easy. Use the following command as a template:

UPDATE
	[table_name]
SET
	[field_name] = REPLACE(
				[field_name],
				'[string_to_find]',
				'[string_to_replace]'
			);