MySQL Find & Replace

Posted: December 29th, 2008 | Author: Matt | Filed under: MySQL, Web Programming | Tags: find/replace, MySQL | No Comments »

Here’s a quick little piece of code to save some time when you need to do a find/replace on your MySQL tables.



update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');