Answers for "mysql update part of string in all column"

SQL
1

update part of a string in mysql

UPDATE table
SET field = REPLACE(field, 'string', 'anothervalue')
WHERE field LIKE '%string%';
Posted by: Guest on April-25-2021

Code answers related to "mysql update part of string in all column"

Code answers related to "SQL"

Browse Popular Code Answers by Language