Delete all spam comments in WordPress

Posted by Darwin Biler on May 20, 2012

If you own or administers a blog, most likely you uses WordPress.
One of the enemies of blogging softwares are spams - people and bots who puts a lot of trashy comments in your posts.

In such a case you forgot to install an anti-spam plugin, chances are you already got hundreds of thousands of comments pouring into your WordPress admin waiting for you to delete.

Thats was not a very and nice task to do - delete or mark each of those comments

The best and fastest solution to this is by deleting the unapproved comments directly via your database

You need to have an access to your database in order to do this (phpmyadmin or ssh)

then execute this: DELETE from wp_comments WHERE comment_approved = '0';

then there you go, problem solved!


Did you find this useful?

I'm always happy to help! You can show your support and appreciation by Buying me a coffee (I love coffee!).