In this tutorial I will show you how to delete all pending comments in WordPress.
Now a days WordPress comment spamming is becoming a common issue. There are some spam prevention methods and plugins that will help you get rid of these issues (I’m not going to discuss about those plugins now). But the thing is, most of us install these plugin after the attack. It will stop the spam issue but you must be having thousands of spam comments in queue (pending status). Removing these spam comments manually is not an easy task and may take weeks or months.
So is there any other options to delete all pending comments WordPress? Yes there is and there are several methods to do it. I’ll show you a MySQL one liner to do this. Please follow the steps given below:
1) Login to your server via SSH.
2) Execute the command given below.
mysql -uDB_USERNAME_HERE -pDB_USER_PASSWORD_HERE -DYOUR_WORDPRESS_DB_NAME_HERE -e "DELETE FROM wp_comments WHERE comment_approved = '0';"
( Please note that, if your WordPress database prefix is something else, please replace “wp_” with that prefix. )