How to delete all unapproved comments in wordpress?

Discussion in 'Databases' started by DomainMagnate, Oct 20, 2010.

0
  1. #1
    How to delete all unapproved comments in wp?
    Basically delete everything where comment_approved=0
    can someone please post the sql code for this to use in phpmyadmin
     
    DomainMagnate, Oct 20, 2010 IP
  2. rayqsl

    rayqsl Active Member

    Messages:
    91
    Likes Received:
    0
    Best Answers:
    1
    Trophy Points:
    53
    #2
    Why not just log into Wordpress, go to the moderation panel and select all unapproved and delete them?

    Saves messing around in the database when you don't necessarily know the underlying database structure.
     
    rayqsl, Oct 20, 2010 IP
  3. DomainMagnate

    DomainMagnate Illustrious Member

    Messages:
    10,932
    Likes Received:
    1,022
    Best Answers:
    0
    Trophy Points:
    455
    #3
    there were 50k comments there ;)
    but i figured a quick way to do it, just emptied the comments db since its all spam anyway
     
    DomainMagnate, Oct 21, 2010 IP