need to delete a lot of comments at once

Is there any way to mass delete about 10.000 comments on a wordpress site quickly?


  • Ivan
    • HummingBird

    Hey Corn,

    Hope you are well and thanks for the question!

    First of all do you want to delete all the comments?
    If this is so continue reading. :slight_smile:

    Are you familiar with phpMyAdmin?

    If so you can do the fallowing
    Backup your database first. See WordPress Backups.

    The you can use phpMyAdmin to execute this SQL

    DELETE FROM wp_comments WHERE comment_approved = 0

    That will delete all not approved comments. If you wanna delete and the approved one use '1' insted '0'
    Of course if your comments table is prefixed with 'wp_' you will need to use the correct table name.

    Let me know if you are comfortable doing this.


Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.