mysql select and replace string code example
Example 1: mysql replace text
UPDATE
table_name
SET
column_name = REPLACE(column_name, 'text to find', 'text to replace with')
WHERE
column_name LIKE '%text to find%';
Example 2: mysql replace
REPLACE(str, find_string, replace_with)
Example 3: mysql find and replace
UPDATE `table` SET `column` = replace(`column`, 'find text', 'replace text')