I have around 1700 pending comments on my website, the majority of which are spam. I thought about just blocking them by IP (wp-ban plugin) or using the comment blacklist feature. However, all the IPs are different. Email addresses? All different. Author names? All different. Content of the message? All different. Every single message is unidentical to another in every way and I am getting fed up of them coming constantly. I don't want to have to delete 85 pages worth of pending comments (even through the select all on page checkbox) and I don't want to accidently delete a legitimate comment.
I have now just activated the Akismet plugin. Will tell you how it does. In the mean time, can anyone suggest on how to delete all the 1700 pending spam comments at once (I have access to phpMyAdmin etc.)