Wordpress

Many many people are suffering bombardments of spam comments on their WordPress blog, and thankfully there are good plugins to help combat that now:

WP-SpamFree Anti-Spam
Yet Another WordPress Anti Spam Plugin

But what if you already have hundreds or even thousands of spam messages sitting in your blog, awaiting moderation? Well, you can get rid of them in one easy step.

*Note* please moderate and approve all legitimate comments before following these instructions. What we are about to do will delete all un-moderated comments.

Please back up your database before making any modifications to it, no matter how simple.

1. Log in to phpMyAdmin
2. Select the database that has WordPress installed
3. Click the SQL tab
4. Enter the following command
   delete from wp_comments where comment_approved = '0'
5. Click the Go button

Job done, all un-moderated comments will be deleted from your blog.