Find & Replace in MySQL

Posted in: Blog- Oct 07, 2009 No Comments

Somewhere between the backing-up and restoration of a clients MySQL WordPress database we picked up some strange characters. Rather than having to go through by hand to edit them out, we used a nice SQL snippet to do a full-database search and replace. update [table_name] set [field_name] = replace([field_name],’[string_to_find]‘,’[string_to_replace]‘); So in this case, to get [...]