Search and replace within a field with regex in MySQL

An article by Urban    No Comments

SELECT * FROM 'table' WHERE `name` REGEXP '\r'
UPDATE 'table' SET 'field' = REPLACE(FIELD,"findvalue", "reaplcevalue") WHERE REGEXP 'regexp search expression'