Answers for "mysql update part of string in column"

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

mysql replace string in table

UPDATE products 
SET 
    productDescription = REPLACE(productDescription,
        'abuot',
        'about');

Posted by: Guest on May-07-2020

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