This is a really useful function - you can find and replace text in any column of a mySQL database using the " replace() " function.

UPDATE table_name
SET column_name = replace(column_name,'text to find','replacement text');

easy!