How to delete mass spam comment in WordPress

Ebooks - Tips, How to — By Script on March 6, 2009 at 6:50 pm

A question that pops up from time to time in the forums is how do I mass delete spam comments? A particular user had neglected his blog for a few months only to return and find thousands of spam comments awaiting moderation. Of course deleting this stuff through the WordPress interface could take hours or even days if you have a lot of spam.

DELETE from wp_comments WHERE comment_approved = ’0′;

Be sure to backup your database first.

As a preventative measure you should also use an anti-spam plugin. On this blog I use both Akismet and Bad Behaviour. Since using these plugins my own spam counts have dropped from hundreds a day to less than a half dozen a month.