If you are like me, and your blogs puts all comments with one link or more in the Pending approval / Moderation queue, and you have over On Hundred Thousand (Not an exaggerated number) comments where at least 99.9% of them are spam, then you need to delete all pending comments without looking at them (Unless you plan to spend the rest of your days looking for that innocent commenter that probably wanted to say hi).
So, i want to do it the simplest way possible..
I want to execute some SQL through PHPMyAdmin that is given to me by my web host, and get all the comments gone
1- Get my Database username and password from wp-config.php
2- Login with the username and password at PHPMyAdmin
3- Chose the Db from the left, Hit the SQL tab from the top, then if your tables start with wp_ (Some may have changed that at install time)
4- DELETE FROM wp_comments WHERE comment_approved = 0;