To delete all unapproved comments in WordPress you can use the following snippet.
Sample mySQL
DELETE FROM wp_comments WHERE comment_approved = 0
To delete all unapproved comments in WordPress you can use the following snippet.
DELETE FROM wp_comments WHERE comment_approved = 0