To delete all unapproved comments in WordPress you can use the following snippet.

Sample mySQL

DELETE FROM wp_comments WHERE comment_approved = 0