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


Leave a Reply

You must be logged in to post a comment.