If you ever need to make changes to your database, but are afraid to mess with data stored in serialized arrays. Interconnect/IT’s Database Search and Replace Script in PHP is the tool for you. It’s an extremely powerful tool that will make a snap of performing search and replace actions on your WordPress databases.
Be warned, part of its ease of use can come back to bite you if an unauthorized user gets access this script. We recommend renaming the directory right after you extract the files. And most definitely delete the script when you’re done, or you’ll probably end up regretting it.
Update: Apparently too many people were not heeding the warnings and then whining to Interconnect/IT about their site getting hacked. You can no longer download the script directly from their site. You now have to sign your life away and be emailed a download link.
The nice part about SARFWD, is that it works directly in the database, so if you’re site’s not working, or you’ve got a lot of changes to make, it can get the job done. There’s also Better Search Replace that works inside of WordPress. We haven’t experimented with this one too much, but it seems like it would get the job done, too. We would recommend not leaving this one installed and enabled on your website out of concern that it is accidentally used, or used by somebody who thinks they know what they are doing.