I got comment spam in my blog, so I downloaded some anti-spam plugins, but they didn't work for me. Finally, I decided to use captchas, so I activated the ReCaptcha plugin and am quite spam-free now (around 2-3 comments per week get through).
But for some weird reason, there's still a lot of spam, but it is all marked as spam and doesn't show up. So my Dashboard looks like this:
You have 37 posts, 4 pages, contained within 18 categories and 193 tags. You have 8,570 total comments, 97 approved, 8,473 spam and 0 awaiting moderation.
How can I delete all these spam comments except using a MySQL query like "DELETE * FROM wp_comments WHERE whatever = 'spam'", is there a button somewhere? Didn't find anything. Or a plugin?
It's quite annoying, I want to do a database backup, and it takes 20 minutes to download all the spam comments I don't want to have anyway.