The SQL that saved my life…

Pretty simple find and replace:

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

OMG, I am glad I listened in the database classes all those years ago 🙂 I’m upgrading an older WordPress blog to the latest version and that lil query saved my life!

Published by Carlo

I'm an online marketing chap for "igaming" companies, which is a cheesy/fancy word for "online gambling". People bet on the internet, just like they buy stuff from Amazon. Shocking I know.

Leave a comment

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.