Akismet – select all on search results?

  • 99.5% of my spam has had the words “i’m agree with you, i think…” at the start. Is there some way that Akismet could apapt to that, as a lot with these words still gets through.

    Also, I want to find all the spam with that phrase, then delete it, but I can’t see a “select all” button on the results page (over 3,000 results!).

    Thanks

Viewing 3 replies - 1 through 3 (of 3 total)

  • Why not just click on the Delete All button?

    Thread Starter digitaltoast

    (@digitaltoast)

    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?

    Thread Starter digitaltoast

    (@digitaltoast)

    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=https://%’ 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 ‘%https://%’ AND comment_approved = ‘spam’

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Akismet – select all on search results?’ is closed to new replies.