This is the SQL command:

DELETE FROM wp_comments WHERE comment_approved = 0

This, as you can see in the screenshot below, says that the operation was executed ok but no rows affected….which is odd b/c I have 13,000 pending comments that I am trying to delete!

Any idea what I might be doing wrong?

There is a plugin that does this but it crashes when I use it – most likely b/c I have 13K comments that need deleting from the pending state…

Thanks for all help