How many of you are sick of all the spam you get on your blog? Ok, stupid question I know. Well I just check my database using phpmyadmin and found I had over 16,000 spam comments waiting for moderation on one of my blogs!
So I tried to find a plugin to handle a mass delete for wordpress 1.5 but nothing seemed to work. So I went old school, logged into phpmyadmin went to the comments table and added this line:
DELETE FROM wp_comments WHERE comment_approved = “0″;
66 seconds later all 16,000 spam comments where gone! I was more than happy. I checked my blog and for what ever reason it seemed to run much faster? Not sure if there is any correlation?
I am sure there are some really good plugins for wordpress 2.0 and beyond but if you want to get it done quick and dirty this way worked fro me.
