Mass Delete Moderated Comments
One of my complaints with WordPress has been that it’s somewhat difficult to do actions on a mass set of comments (as became obvious with the recent deluge of comment spammers). Anyway, for those who might want to do a mass delete of 100’s of comments spams (or like me when a certain new spammer decided to attempt to spam my blog 2500 times in 2 days before I threw him in my filter), here’s a quick and dirty way to delete ALL of your moderated comments…
Simply connect to your mysql database (using mysql or phpmyadmin) and run the following query:
delete from wp_comments where comment_approved = '0';
Anyway, since I’m in the process of upgrading my blog, ALL comments are current moderated, so if you reply here, it won’t show up immediately at the moment.