Cleaning Up WordPress Comments | Mass Deleting WordPress Spam Comments | Mass Deleting WordPress Comments

Wordpress Comment Delete

Have 1000+ Comments to be deleted on your Blog? And Bored of doing 20-20-20 Deleting from the Dashboard which could take you hours? Here is a Quick go to delete your Comments, No matter whether they are Spams, Approved or pending comments.

Deleting Pending Comments

1. Go to Your Phpmyadmin. (Login to Cpanel and Click Phpmyadmin in under Database Section)

2. Select your WordPress site's Database from there.

3. Click SQL tab.

4. Enter this and Click Go.

delete from wp_comments where comment_approved="0";

Press YES in the prompt coming. And Your Comments will be deleted

To Delete Spam Comments

1. Follow all steps mention above till Step 3.

2 . Enter this and Click Go.

delete from wp_comments where comment_approved="spam";

Press YES in the prompt coming. And Your Comments will be deleted

To Delete Accepted Comments

1. Follow Steps till 3.

2. Enter this and click Go.

delete from wp_comments where comment_approved="1";

Press YES in the prompt coming. And Your Comments will be deleted

To Delete All the Comments, Do all the steps one by one and you will be free from all the comments you had.

5 Responses to “Cleaning Up WordPress Comments | Mass Deleting WordPress Spam Comments | Mass Deleting WordPress Comments”

  1. What a nice post. Now it's very easy to delete all spam comments quickly.

  2. Jussi Sivonen January 12, 2012

    How about the table called "wp_commentmeta"? That one has also data concerning the comments. Does it mess up the database (or at least leave a lot of unneeded data) if that table is untouched? I'd say that touching only the wp_comments table is not a proper way to handle the spam, unless the identical id-values are cleaner from the wp_commentmeta table.

    I'd love to see a simple solution for that...

  3. postings are pretty good, so it's easier to avoid spam

  4. Very nice !!!

  5. Thanks for this, now my cousin can keep his site clean.

Leave a Reply