Mysql replace string example

Categories: 

Tags: 

Example to replace domain url

UPDATE your_table SET column_name = REPLACE(column_name, 'old.domain.to.change.com', 'new.domain.com') WHERE column_name LIKE '%old.domain.to.change.com%';