Mar 15, 2018

MySQL string replace

UPDATE your_table
SET your_field = REPLACE(your_field, 'old_string', 'new_string')
WHERE your_field LIKE '%old_string%'