Trying to delete spam comments/trackbacks in phpMyAdmin

  • daisyhead

    (@daisyhead)


    19 years, 2 months ago

    I’m trying to help a friend delete HUNDREDS of trackback spams that she received over the weekend and her install of WP is messed up. We are unable to do a “select all” to delete all the comments at the same time.

    What query would I run in phpMyAdmin to delete the spam comments/trackbacks?

    Thanks!
    Daisyhead

Viewing 1 replies (of 1 total)
  • Kafkaesqui

    (@kafkaesqui)

    19 years, 2 months ago

    First, back up the database.

    Next, use as your query:

    DELETE FROM wp_comments WHERE comment_author_url REGEXP "SPAMTEXT";

    Replace SPAMTEXT with a word or phrase that appears in the URL they’ve supplied. As this removes a record from the database, be certain of the text (and again, back up!).

Viewing 1 replies (of 1 total)
  • The topic ‘Trying to delete spam comments/trackbacks in phpMyAdmin’ is closed to new replies.