In the Following Simple Solution I will show you how to Bulk Delete WordPress Comments directly from the WordPress database. If you have hundreds of pending WordPress comments that are mainly spam comments, it can take forever to delete them manually via the WordPress dashboard. By using the following process to delete WordPress Comments, you can achieve this goal in a matter of seconds.
How to Bulk Delete WordPress Comments
Bulk deleting WordPress Comments is as easy as running an SQL query from the database. Here's how I did it;
- Login to your hosting services CPanel and navigate to phpMyAdmin
- Select the database where your WordPress install is located
- (1) Click the SQL tab
(2) enter the following information in the Run SQL query box:
DELETE FROM wp_comments WHERE comment_approved = '0'
(3) Click Go
- Login to your wordpress admin dashboard and if all has gone well, the pending comments should now be gone.