Help! How to delete “comments in moderation” all at once.

  • Hello,
    My blog has been spammed like crazy so that there are 2,451 “Comments in Moderation”.

    Does anyone know how to do a “delete all” in the comments in moderation? I used to be able to quickly hit the radio buttons to “delete” by each comment, and then go down to the bottom of the page and hit the button the deleted all at once. But now with so many comments waiting in moderation, I don’t get those buttons at the bottom to delete all that I’ve checked – anyone know a solution? I’d just like to go nuclear and just delete all comments.

    Thanks!

Viewing 1 replies (of 1 total)

  • Login to phpMyAdmin and run this query…

    DELETE from wp_comments WHERE comment_approved = '0';

    A warning: phpMyAdmin is a powerful tool for directly interacting with your database. Exercise caution as there is no “undo” button. You may want to make a backup prior to proceeding.

Viewing 1 replies (of 1 total)
  • The topic ‘Help! How to delete “comments in moderation” all at once.’ is closed to new replies.