Answers for "how to search data and replace it in mysql table"

mysql find and replace

UPDATE `table` SET `column` = replace(`column`, 'find text', 'replace text')

Posted by: Guest on May-21-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 "how to search data and replace it in mysql table"