Is there a way to revert many/all posts to the closest revision to a particular date, all at once?

The specific use case I need it for is to remove all the spammy viagra links from the content on a briefly-infected blog.

Any solution welcome.

1 Answer 1


Probably is a way with an SQL query.

But another solution is to use Search RegEx, which is a good plugin to be able to search and replace with grep and regular expressions through all posts and pages. And I'd delete all your revisions to make sure the links aren't hidden in old revisions that might get restored at some point.

If you need to develop a regex search string to find spammy href links, check https://stackoverflow.com/questions/tagged/regex

And you can search for text strings with phpmyadmin in your Cpanel, or better yet, adminer, which is simpler and more secure. WordPress › Adminer « WordPress Plugins.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.