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
Dan Atrill's blog site
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
Wed, August 8 2007 » MySQL