How to Delete All Mass Spam WordPress Comments At Once

Every WordPress users wants to delete the spam comments from their WordPress website at once, If you are among of those and you want to delete all spam comments at once from your WordPress site, Then you are reading the right article, There three ways to deal with the spam comments, First method very simple deleting from WordPress built-in feature, and the second method, deleting by the plugin, the third method deletes from phpmyadmin, In this is tutorial we gonna cover all three methods so you will learn all three methods. So have a look below methods.

Method #1

First of all login to your WordPress and go your comments tab, There you will see a little button called "Empty Spam" click on that button, Note this may take too long time, and it could also take down your web server, if you are deleting hundreds or thousands of comments at once

Method #2

There many plugins that can deal with the spam comments on your WordPress site, One of the free plugins which I gonna use in this tutorial is "Delete Comments By Status" with this plugin you can delete by status lets say if I want to delete all Approved comments or Pending even Spam then I will select that status and hit delete that's how simple is it, so install the plugin and activate it. Once you have installed the plugin, Then go to your WordPress settings tab and then you will see new delete comments tab, click on that tab and you will see the page with check boxes, Select one of the select one of the option and hit submit.

Method #3

Before using this method you should backup your WordPress. After you backup your WordPress site then go to your web hosting account and go to your cpanel and click on phpmyadmin, it must be under the database section. and the copy the below SQL query to delete all the spam comments only.

DELETE FROM `wp_comments` WHERE `comment_approved` = 'spam'

In the above SQL query we are telling the SQL database server to delete the all comments that comment_approved = spam, it's mean to delete all comments from the database which is spam. BTW wp_ is my prefix if your database prefix is different then change with it. Once to copy the SQL query, then go to phpmyadmin at your cpanel and then to wp_comments table and click on SQL tab and paste that query there and click on go

Once you run the query you will see a success message.

If you Liked this tutorial then please like and follow us Twitter, Facebook

Author

I am Aizaz.Dinho and I loved to learn new things and teach to people like you, In my mind I'm the one who can do anything whatever I want, From my heart am still learner and loved to do impossible things, Web Development is my passion and I have PHP, MYSQL OOP PDO, Blogger WordPress also SEO experiences, You can say I'm the code ninja of meralesson