Delete ALL Unapproved comments in WordPress

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.

DELETE FROM wp_comments WHERE comment_approved = 0

That’s all.