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.