is there a way to quickly delete 38,768 spam comments?

  • Resolved butterflyherder

    (@butterflyherder)


    15 years, 4 months ago

    Hi there –

    I just inherited a client from another web designer. He hadn’t updated the client’s WP for about 3 years. I just finished doing the updated, but now there are (literally) 38,768 spam comments that I’d like to delete.

    Is there a way to do it quickly?

    So far, I’ve only been able to delete 20 comments at a time.

    Any ideas?

    Thanks!
    Cynthia

Viewing 3 replies - 1 through 3 (of 3 total)

  • Press the “Delete all spam” button?

    Thread Starter butterflyherder

    (@butterflyherder)

    Tried that… unfortunately, the spam comments are still in the “pending” category. So it hasn’t really classified them as spam yet.

    If you want to delete all pending comments you can use phymyadmin or the mysql client to run

    delete from wp_comments where comment_approved = 0

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘is there a way to quickly delete 38,768 spam comments?’ is closed to new replies.