How to remove tons of spam comments at once in Wordpress

[cvrle77]

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

select count(comment_ID), comment_approved from wp_comments group by comment_approved;

Or, you can delete all spam comments with this command

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 9th Aug 2012. 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