MySQL Search and Replace »
I really, really wanted to do a search and replace in MySQL, but I just couldn't find it. Then I did.
update tablename set field = replace(field,'search','replace');
I really, really wanted to do a search and replace in MySQL, but I just couldn't find it. Then I did.
update tablename set field = replace(field,'search','replace');