How to Find & Replace in MySQL

How to Find & Replace in MySQL featured image

Sometimes, we need to find and replace certain strings or pieces of data in MySQL on the fly, for example if we’ve changed a Top Level domain (TLD) and want to update a bunch of links all in one go. For those times, the following command can be issued: update [table_name] set [field_name] = replace([field_name],'[string_to_find]’,'[string_to_replace]’); […]

WordPress – Using MySQL to Update Specific Custom Fields

WordPress – Using MySQL to Update Specific Custom Fields featured image

Some time ago, we told you how to Find & Replace Data using MySQL – today I am going to explain how to use this query to update specific custom fields in WordPress databases, in bulk, on-the-fly, without having to login, open, and edit every single WordPress post you’ve got! Remember, before doing anything to […]

Silicon Dales