Mass Edit WordPress Posts with Regular Expressions
Picture this: you have a thousand posts in your blog and some maliciously minded individual (not my first choice of words) comes along, sticks his digital hatchet into your database and hacks away at it until every post is filled with spam links to Viagra stores. Just as you think things can’t get any worse, they just did: you’ve written 30 posts since your last database backup!
What do you do?
Is there a quick way to get rid of all that lovely free Viagra advertising you’re giving away?
Along Comes Search Regex
Search Regex is the search and replace plugin I use most. It allows a WordPress database to be scanned for specific words and phrases which can then be replaced or deleted. There is no need to physically browse a site’s database because everything can be done from its WordPress admin panel (a picture of that follows in a few paragraphs).
In technical lingo, those words and phrases…