MySql - Way to update portion of a string?
I think this should work:
UPDATE table
SET field = REPLACE(field, 'string', 'anothervalue')
WHERE field LIKE '%string%';
UPDATE `table` SET `field` = REPLACE(`field`, 'string', 'anothervalue')
I think this should work:
UPDATE table
SET field = REPLACE(field, 'string', 'anothervalue')
WHERE field LIKE '%string%';
UPDATE `table` SET `field` = REPLACE(`field`, 'string', 'anothervalue')