Search and replace
Last Updated on Wednesday, 8 August 2007 12:43 Written by Dan Wednesday, 8 August 2007 12:43
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
