Search and Replace within WordPress

I was given an intriguing task today; replace a URL within every WordPress to an updated URL. It doesn’t really sound that hard you just replace Site A with Site B. But what happens when you have hundreds of posts? It’s not really that simple any more, but I found a fantastic and easy to use WordPress Plugin that took care of the job in mere seconds. Enter Search and Replace for your Database.

The plugin is called Search and Replace and when activated gives you a simple screen of checkboxes on where you want to look for your search string. You can change the content of the post, the title, the Author and several other criteria. And then as you would expect you enter the string to search for and what you want to replace it with. Boom it’s done.

This directly changes the database so the changes are permanent. As the instructions say, make a backup before you make any changes. But wow, does this tool work like a charm! It took mere minutes to make the changes.

Normally this level of trickery should be done by a DBA, but what if you don’t have access to one, or what if your data is stored on someone else’s server? This is an easy to handle the job and it saved a lot of manual labor. I’ll be keeping this plugin at the ready, I’m sure it’ll be needed again.

 

Search and Replace for Content

http://wordpress.org/extend/plugins/search-and-replace/

Other articles of interest:

Leave a Reply

Your email address will not be published. Required fields are marked *

Recent Comments
  • How To Disable the Quicken Registration Prompt (10)
    • Jack Woltz: Worked great but now I get update nag which is worse
  • How To Download Movies From Hulu Using Freemake Video Downloader (1)
    • Doomups: I often use allavsoft to download Videos from Hulu on Mac and Windows. And it also can batch and Direclty Download Hulu Videos to MP4, WMV, MOV, AVI, FLV, etc.
  • Why is Daemon Tools Lite triggering Norton Internet Security Anti-Virus? (1)
    • Jaguar: What’s an alternative to using daemon tools? That would be useful to know.
  • Loot Drops for the last few hours of Season Surprise Event – Crime City (1)
  • Topping out with a Trillion Dollars in Crime City (13)
    • Don Pedro: So, just to show how ridiculous things have become, a few weeks ago, I crossed over the 3 Trillion mark in cash. My income has moved to 525.7M IPH. I have both Luggage Lugger buildings upgrading and am working to upgrade the...
    • Tom Offski: Thank you
    • Don Pedro: My income is all from buildings. I have just about every LTB they’ve introduced. I skipped one or two based on their enormous size and terrible income/upgrade costs. Almost all of those buildings are now level 10s. The...
    • Tom Offski: Hey, I’ve been playing sonce 2013, but stopped for a year and a half mid-way. My IPH is 1.05m, and my main source of income is a certain job which gives you 2-7mil for 178 energy… how do you make so much money? Is...
    • Don Pedro: I am very familiar with the time of which you speak. That is when I first came on board as well. There were some good prizes back then such as the decrease in deposit fee. Some of those old buildings are somewhat laughable...
    • Duane Stovall: Yeah 3 of the 5 building upgrades are working on the older regular buildings now. I’ve got all the LTB’s up to level 10. Started playing when FUNZIO owned CC…so was able to purchase every LTB that came...
    • Don Pedro: Upgrading 5 buildings at a time? Damn son! And your IPH is a lot higher than mine. I’ve only got 485 with 3 upgrades at a time, of which I’ve only been using 2. I’ve thought about getting another upgrade...
    • Duane Stovall: I’m up to 517mil iph…just hit my first trillion in the bank. Would have hit a while back…but started a baby syn for my two smaller accounts and maxed out most of the bonuses with the help of one other...
    • Up!: Wow, and here I come with 2m iPH trying to build up a syn.. How long have you been playing? I do think that for normal accounts (without the reduction) its cheaper to leave the money out, being robbed 10% .. would mean in my case 5m...
  • Put another trillion on the fire – Crime City (1)
    • Paul: Im right behind u Scabby at 425 mil iph!! Wish there were better 12 hour buildings coming out
  • New version of Freemake Video Downloader brings back YouTube Playlist downloads (1)
    • ALI: Hi there, I have been trying to download a playlist contains more than 300 episodes but when I copy and paste the link into freemake video downloader app, I can only download max of 100 videos only. Is there anyway to download all...