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'; 

All unapproved comments will be removed.

Leave a Reply

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