WordPress Tip: Search and Replace Post Content

I was working on a client blog and helping them convert from a Microsoft IIS website where everything was .asp based to a WordPress CMS system.  In doing so I had to port over and manually create dozens of WordPress posts from static .aspx pages.

This was accomplished but one of the biggest hassles was fixing up all the URI/URL structure of the converted blog where many posts/pages referenced other posts/pages/URI’s on the same site except with the dreaded .aspx extensions.

Being that I am no SQL expert, having to run manual find/replace SQL queries was something I didn’t feel like tackling at midnight when I did the work, so I found a WordPress plugin called Search & Replace which does everything I needed.

image

Just install Search and Replace and then go into your WordPress Settings to find the plugin options.  This plugin allows you to search and replace content data in your WordPress database and does a phenomenal job of finding/matching data and allowing you to restrict it to specific area’s of your database.

Most of this stuff is fairly technical, so by default it will only search/replace the date in your actual content (post body area).  You can also have it find/replace content in Titles, Excerpts, Meta Data, comments, author, ID, categories…etc

image

For my testing I only needed to replace URI’s in the Post Content.

So something really simple like replacing a forms.aspx page which was referenced now in many posts I could replace with the proper URI for the page.

image

Of course you should backup your WordPress Database before making ANY Changes just in case.  I did this and making a backup before you do any sort of mass change is critical to avoid any potential mishap.

image

I did a dozen search/replace function and replaced hundreds of entries which was a huge time saver.  Search and Replace is a great WordPress plugin for helping you correct broken URL’s, entries or replacing old affiliate links with new ones across all your WordPress blog post content.

Best of all, the plugin is free!

-Dragon Blogger

Justin Germino
I have been obsessed with computers, tech, gadgets and games since the early 1980's having grown up on the Commodore 64 and Amiga computers. By day I work in the IT Security Industry and have been in IT for over 20 years. On my spare time I am a Vlogger, Blogger, Streamer, Gadget Reviewer, affiliate marketer, influencer and entertainer. I am also an avid movie fan, TV Show fan, Anime fan, video game fan and fan of trying anything and everything new.
Justin Germino

@dragonblogger

Content Creator/Owner of https://t.co/iWP6afuOc9 for Tech, Game, Entertainment and streamer at https://t.co/594fXMdMIA
Justin Germino
Justin Germino
Share Feedback We Want to Hear From You