my sql replace syntax code example

Example 1: mysql replace

REPLACE(str, find_string, replace_with)

Example 2: mysql replace string in table

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