mysql column value replace code example

Example 1: mysql replace string in table

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

Example 2: replace null value within column mysql

UPDATE `table` SET `somefield`=0 WHERE `somefield` is null