Delete WordPress Comments in Bulk

In this post I will try my best to show and explain the steps to delete all the spam comments within a minutes. Although, you can delete the comments from WordPress admin but it’s a time killer job therefore, I am going to show the easy way out to remove thousands of comments in a short time span of few seconds however, if you are new user it might take two minutes.

1 – Login to you web hosting Cpanel by supplying username and password.

2 – Once you entered the CPanel, click on phpMyAdmin under database section.



3- If you have multiple blogs hosted on your web server in that case you have to select the WordPress blog database.

4- Click the SQL Tab from the menu as shown in below snapshot.


5- Enter the following query in editor.

DELETE FROM wp_comments WHERE comment_approved = ‘0’


6- Click GO button to execute the query.


7- Now login to WordPress Dashboard now you can see that all the pending comments are gone.

Tags: , , , ,

Author: Revo

Share This Post On

Submit a Comment

Your email address will not be published. Required fields are marked *

17 − three =


Pin It on Pinterest

Share This