PHPmyAdmin question

Discussion in 'Databases' started by stationq, Jun 5, 2008.

0
  1. #1
    This should be simple for most but not me :(

    I am trying to delete all comments(spam) from my wordpress site, I am accessing it thru PHPmyadmin but am unsure as to do this exactly.

    Thanks to all who reply
     
    stationq, Jun 5, 2008 IP
  2. ckgni

    ckgni Active Member

    Messages:
    208
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    58
    #2
    If you are sure that all comments are spam, then the following command will delete all comments from your Wordpress blog:

    DELETE FROM wp_comments;
    Code (markup):
    Just click on "SQL" tab of your phpMyAdmin and paste the command there.
     
    ckgni, Jun 5, 2008 IP
  3. Stephanie_Lee

    Stephanie_Lee Banned

    Messages:
    55
    Likes Received:
    9
    Best Answers:
    0
    Trophy Points:
    0
    #3
    or just select the table wp_comments and select Empty
     
    Stephanie_Lee, Jun 7, 2008 IP