I think you will know this situation: You go to your WordPress admin panel and there are 100′s of pending spam comments. Now you can only send 20 comments at once to the trash. This will take you unnecessary time. I will now give you step by step instructions for a really fast and simple solution to remove all your pending comments at once:
1. Open your WordPress mysql database in phpMyAdmin.
2. Find out the name of your WordPress comments table (mostly it is “wp_comments”).
3. Click on the “SQL” tab at the top of the page.
4. Insert the following mysql command to the text box and click “Go”.
If your WordPress comments table has another name than “wp_comments”, replace it with your table name.
Within seconds all your pending comments are removed. You will save a lot of time with this solution.