Why not just click on the Delete All button?
Sorry, perhaps I didn’t make the original point clear enough.
99.5% of my spam is spam. On very rare conditions, there’s spam that DOESN’T contain those words, and of that, occasionally, a genuine comment gets through.
I currently have 28951 bits of spam to look through, and get roughly 4 spams per minute. By deleting all the “i’m agree with you” spam, I could narrow it down to probably a handful to check through.
So, to clarify again, I want to delete all the RESULTS and not all of what Akismet thinks is spam.
Otherwise, why would there be searches if it wasn’t to exclude stuff?
Well, after a couple of hours I managed to work out roughly how to reduce the spam to something manageable, checking after each one to see if it was a sensible size yet.
After running this lot, I was down to 545 spams, which I could at least page through.
DELETE FROM wp_comments
WHERE comment_content
LIKE ‘%agree%with%you,%i%think…%’ AND comment_approved
= ‘spam’
DELETE FROM wp_comments
WHERE comment_content
LIKE ‘%[url=http://%’ AND comment_approved
= ‘spam’
DELETE FROM wp_comments
WHERE comment_content
LIKE ‘%viagra%’ AND comment_approved
= ‘spam’
DELETE FROM wp_comments
WHERE comment_content
LIKE ‘%cialis%’ AND comment_approved
= ‘spam’
DELETE FROM wp_comments
WHERE comment_content
LIKE ‘%http://%’ AND comment_approved
= ‘spam’