{ MySQL update / replace }

Here’s some SQL that’s great for “mass” replacing of URLs in a database:

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

Leave a Reply

Your email address will not be published. Required fields are marked *