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. Maybe next time ). 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. ( You don’t have to login to MySQL command prompt )
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. )
What if you don’t have command line access ( Maybe Shared server environment ) or don’t want to deal with the SSH or command line? Don’t worry, there are several WordPress plugins that do this same thing without messing with your database directly. You can download one plugin from here
This will do the trick and will delete all pending WordPress comments.