Delete ALL Unapproved comments in WordPress
February 4, 2015
Make a backup first before changing anything.
Go to PhpMyAdmin and select the comments table (usually wp_comments). Go to the SQL tab and run the following command.
code
DELETE FROM wp_comments WHERE comment_approved = 0
That's all.