finding matching values in a string and replacing the in mysql code example
Example: mysql replace string in table
UPDATE products
SET
productDescription = REPLACE(productDescription,
'abuot',
'about');
UPDATE products
SET
productDescription = REPLACE(productDescription,
'abuot',
'about');