[resolved] SQL to Mass delete specific comments (3 posts)

  1. TonyGeer
    Posted 6 years ago #

    A client's blog has managed to accumulate a very large number of spam comments that are all identical. I'm trying to mass delete all of them using SQL in phpMyAdmin. I think it should be fairly easy as all of the comments are identical and have the text "Gucci Bags" in them.

    Can someone help me out with the SQL to accomplish this?

  2. mrmist
    Forum Janitor
    Posted 6 years ago #

    Something like

    DELETE FROM wp_comments WHERE comment_content like '%gucci%';

  3. TonyGeer
    Posted 6 years ago #

    This worked perfectly, thanks!

Topic Closed

This topic has been closed to new replies.

About this Topic