help me- how to delete all comments at my wordpress blog

Discussion in 'WordPress' started by aaheroe, Nov 29, 2007.

0
  1. #1
    hello

    can u help me delete all comments

    because i check at phpmyadmin comment table usage 140 mb for it ( 90% spam comments )

    i dont use askimet :(

    anyonecan help me how t delete it all ?

    thanks
     
    aaheroe, Nov 29, 2007 IP
  2. NiTS.In

    NiTS.In Peon

    Messages:
    175
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Mass edit mode isn't working? yourdomain>wp-admin/edit-comments.php?mode=edit
     
    NiTS.In, Nov 29, 2007 IP
  3. ngcoders

    ngcoders Active Member

    Messages:
    206
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    55
    #3
    140 MB :) , Write a small script to clean it .

    OR try something like -> DELETE FROM wp_comments WHERE comment_content LIKE "%viagra%" ; in phpmyadmin

    a few such queries will take care of most :) . Next time use Askimet
     
    ngcoders, Nov 30, 2007 IP