3 {{ upvoteCount | shortNum }}
3 {{ upvoteCount | shortNum }}

How to delete comment at once

by Face Cap
2 replies
  • WEB DESIGN
    • |
HI

I have about 6k Comment messages on my blog that seems spam-Is there a way i can delete all messages once instead of deleting in batches- Its stressful
#comment #delete
  • Profile picture of the author MikeFriedman
    Originally Posted by Face Cap View Post

    HI

    I have about 6k Comment messages on my blog that seems spam-Is there a way i can delete all messages once instead of deleting in batches- Its stressful
    Install WP-Optimize.

    It will let you remove all unapproved comments with the click of a button.

    It also has an option to turn comments off. I would advise doing that.
    {{ DiscussionBoard.errors[10120691].message }}
  • Profile picture of the author Member8200
    Other solution,

    Backup your database first. See WordPress Backups.

    The can use phpMyAdmin to execute this SQL
    DELETE FROM wp_comments WHERE comment_approved = 0
    Of course if your comments table is prefixed with wp_ you will need to use the correct table name.
    {{ DiscussionBoard.errors[10121810].message }}

Trending Topics