All you need to know is that unapproved comments are marked with 0 and approved comments are marked with 1.

Back up your db and then running the following query making sure you have the right table prefix for your db.

DELETE from wp_comments WHERE comment_approved = ‘0’;

or

DELETE from wp_comments WHERE comment_approved = ‘1’;