mysql

UPDATE table_name SET column_name = REPLACE(column_name, 'before', 'after');