mysql replace substring update code example

Example 1: mysql replace string in table

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

Example 2: search for replace in mysql

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