Answers for "mysql result substitute character in all columns"

mysql replace a character in a string

UPDATE users SET first_name = REPLACE (first_name, 'search', 'replace_with') where id > 0;

update part of a string in mysql

UPDATE table
SET field = REPLACE(field, 'string', 'anothervalue')
WHERE field LIKE '%string%';

mysql replace string in table

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