This tutorial is for WORDPRESS + AKISMET activated only

You can use Wordpress directly, by installing plugin named Adminer, which is PHPMyAdmin inside wordpress.

Once you enter it, look in left corner for this:



Click on SQL command

You can check for the number of spam comments using this command

Code: 
select count(comment_ID), comment_approved from wp_comments group by comment_approved;
Or, you can delete all spam comments with this command

Code: 
delete from wp_comments where comment_approved = 'spam';
Don't forget to hit 'execute' button, once you type in command
cvrle77 Reviewed by cvrle77 on . How to remove tons of spam comments at once in Wordpress This tutorial is for WORDPRESS + AKISMET activated only You can use Wordpress directly, by installing plugin named Adminer, which is PHPMyAdmin inside wordpress. Once you enter it, look in left corner for this: http://i.imgur.com/9cl68.jpg Click on SQL command Rating: 5