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
Working in the IT Industry for over 17 years starting with OS, Networking and then moving into web based technologies including authentication and online security. Dragon Blogger has unique insights and opinions to how the internet and web technology works. An Avid movie fan, video game fan and fan of trying anything and everything new.
Justin Germino

@dragonblogger

https://t.co/iWP6afuOc9 is a technology, gadget, software and video game site that features articles, reviews and giveaways.
I'm now streaming on Twitch! Playing The Dark Pictures Anthology: Man of Medan https://t.co/5hOVDBWLep - 1 hour ago
Justin Germino