How to Batch Removing Unapproved Comments from WordPress
Most of the important data in a WordPress site such as comments is stored in a database on your web host’s server. So first of all, backup your WordPress database. Then, login to your phpmyadmin, select your WordPress blog database and click on SQL. Then, insert the following sql command and run:
DELETE from wp_comments WHERE comment_approved = '0';
How to Batch Removing Unapproved Comments from WordPress
Most of the important data in a WordPress site such as comments is stored in a database on your web host’s server. So first of all, backup your WordPress database. Then, login to your phpmyadmin, select your WordPress blog database and click on SQL. Then, insert the following sql command and run:
All unapproved comments will be removed.