Originally Posted by fris

via mysql command

Originally Posted by suziqt

also, if you are not comfortable with fris's solution, you can change the amount of comments that appear under "screen options". The default is 20 but i have mine set to 100.

Originally Posted by papill0n

or you can just use the 'delete pending comments' plugin
http://wordpress.org/extend/plugins/...ding-comments/

Originally Posted by colmike7

either use akismet's 'delete all' button if you use that, setting the max in screen options or this in phpmyadmin but always back up your database before doing it:

Delete from wp_comments where comment_approved = 0

note: If your comments table is prefixed with wp_something will need to use the correct table name.