4 {{ upvoteCount | shortNum }}
4 {{ upvoteCount | shortNum }}

How to remove spam comments

by pingsters Banned
3 replies
I have a WordPress blog and did not worked on it for a long time. Now there are 25 to 30 thousand spam comments. I want to delete them but all i can do is just delete 120 at a time. I don,t want to waste my time. Is there a way to delete all the comments at once.
#comments #remove #spam
  • Profile picture of the author sanhal
    This was answered in another thread a while back.

    Here's the answer:

    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!

    Here's the original thread:

    http://www.warriorforum.com/main-int...wordpress.html

    Hope it does the trick.

    Sandy
    Signature
    FREE Guide: 3 Day Clean Eating Challenge
    {{ DiscussionBoard.errors[7968412].message }}
    • Profile picture of the author Andre Slater
      Originally Posted by sanhal View Post

      This was answered in another thread a while back.

      Here's the answer:

      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!

      Here's the original thread:

      http://www.warriorforum.com/main-int...wordpress.html

      Hope it does the trick.

      Sandy
      Also make sure you have Akismet working
      Signature
      -=My Personal Blog=-
      {{ DiscussionBoard.errors[7968501].message }}
  • Profile picture of the author pingsters
    Banned
    thanks for your reply. My problem is solved.
    {{ DiscussionBoard.errors[7972699].message }}

Trending Topics