Search and replace

In very few lines it’s possible to search and replace text in MySQL:
UPDATE table_name SET column_name = replace(column_name,”find_this”,”replace_with_this”)
Thanks to Torkil Johnsen’s Search and replace in MySQL article

Leave a Reply