replace mysql

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 `table` SET `column` = replace(`column`, 'find text', 'replace text')

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

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