MySql – Way to update portion of a string?

December 29, 2022 by Tarik

I think this should work:

UPDATE table
SET field = REPLACE(field, 'string', 'anothervalue')
WHERE field LIKE '%string%';