Mass Deleting Pending Comments

Hi,

I have hundreds of comments in WP that are awaiting moderation. And I believe that they are all trash. How do I delete them all in one go. If I go through the dashboard, I can delete 20 of them at a time!

Thanks
Ajeet

 

If you use the default Askimet plugin that's already uploaded for you you can set it to delete posts older than 30 days. That way you can just check the latest posts and the older ones are automatically deleted.

 

Go to your cpanel and open phpmyadmin and run these Query :

delete from wp_comments where comment_approved = '0'

 

I found a great plugin awhile back for pending comments that pile up. You can download it HERE.

 

Activate askimet. add askimet API. and then click check for spam button on comment page.
Askimet will check all pending comments and will delete the spam ones.