mysql replace text

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

1UPDATE
2    table_name
3SET
4    column_name = REPLACE(column_name, 'text to find', 'text to replace with')
5WHERE
6    column_name LIKE '%text to find%';

1REPLACE(str, find_string, replace_with)
2

1UPDATE products 
2SET 
3    productDescription = REPLACE(productDescription,
4        'abuot',
5        'about');

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

1#REPLACE(string, from_string, new_string)
2SELECT REPLACE(myText, "a", "b") as myText FROM tableText;