12 {{ upvoteCount | shortNum }}
12 {{ upvoteCount | shortNum }}

Is There A Way To Bulk Delete Spam Comments On Wordpress?

by Hamida Harland
7 replies
I just logged in to one of my wordpress blogs that I hadn't checked in a while and it's got over 1000 spam comments (my own fault as I forgot to activate Akismet). Is there any way to bulk delete the comments or do I have to do it page by page?
#bulk #comments #delete #spam #wordpress
  • Profile picture of the author steve39
    I had a similar experience a while back. Had a blog without Akismet and neglected it for months. I never thought spam would be a problem because it had little traffic to begin with. Lo and behold, I opened my admin one day and found thousands of spam comments. I deleted them a page at a time. So, while there may be a way to mass delete, I didn't find it. Those spammers create more work for me than you can imagine...
    Signature

    {{ DiscussionBoard.errors[990264].message }}
    • Profile picture of the author Sudar
      If the comments are in the moderation queue, then you can activate Akismet and click "Check for spam" button. Once all of them are identified as spam, you can delete all of them by clicking the "Delete all spam" button.
      {{ DiscussionBoard.errors[990281].message }}
  • Profile picture of the author Fernando Veloso
    Askimet can go one month back.
    Signature
    People make good money selling to the rich. But the rich got rich selling to the masses.
    {{ DiscussionBoard.errors[990270].message }}
  • Profile picture of the author Devon Brown
    There should be a little check-mark button up at the top that will allow you to "select all" and you can delete in bulk from there.

    Otherwise, take the others advice and see if Akismet can go back into time.
    Signature
    Click Here To Make $2.63 - $5.93 Per Click As A JV/Affiliate!!
    Follow Me On Twitter, Facebook [/B],Visit My Blog
    {{ DiscussionBoard.errors[990284].message }}
  • Profile picture of the author JayXtreme
    Hamida...

    You can do this in phpMyAdmin with a simple line of code..

    Log in to phpMyAdmin

    Select the relevant WordPress database

    Hit the SQL Tab

    And type in the following command:

    delete from wp_comments where comment_approved = '0'

    ^ (Copy and paste from here to ensure accuracy) ^

    This will remove all unapproved comments in a millisecond!

    Peace

    Jay
    Signature

    Bare Murkage.........

    {{ DiscussionBoard.errors[990292].message }}
    • Profile picture of the author Hamida Harland
      Originally Posted by JayXtreme View Post

      Hamida...

      You can do this in phpMyAdmin with a simple line of code..

      Log in to phpMyAdmin

      Select the relevant WordPress database

      Hit the SQL Tab

      And type in the following command:

      delete from wp_comments where comment_approved = '0'

      ^ (Copy and paste from here to ensure accuracy) ^

      This will remove all unapproved comments in a millisecond!

      Peace

      Jay
      That's exactly what I was looking for . Thanks Jay.
      Signature
      {{ DiscussionBoard.errors[990297].message }}
  • Profile picture of the author Baystreet
    If you don't want to go the phpMyAdmin route you can use a plugin call WordPress Suicide

    http://justinsomnia.org/2006/04/wordpress-suicide/

    I just deleted over 97,000 comments on a blog that I have not looked at in three years.
    {{ DiscussionBoard.errors[990327].message }}

Trending Topics