Home > Just the Video Tutorials, WP Comments, WP database > How to Mass Delete Unapproved WordPress Comments

How to Mass Delete Unapproved WordPress Comments

January 27th, 2009 Leave a comment Go to comments

How to Mass Delete Unapproved Comments from Your WordPress Database Using phpMyAdmin

Get Noticed with a $7.99 .CO!
  1. Sarah
    January 29th, 2009 at 05:53 | #1

    Hi, I need a small help. While posting a comments for first time it will show as “No Responses to Post title” and “Your comment is awaiting moderation.”. But what I need is don’t want to display that message. Instead of that I need to display a session message. How can I do that?

  2. February 12th, 2009 at 18:40 | #2

    Thank you for this great tutorial!

  3. Miriam
    March 24th, 2009 at 10:53 | #3

    Deleted rows: 53622 (Query took 12.2305 sec)

    THANK YOU!

  4. April 9th, 2009 at 10:00 | #4

    Great tutorial. Thanks so much.

  5. April 11th, 2009 at 10:38 | #5

    Super ! Pour ceux qui veulent accélérer la procédure et connaissent un peu phpMyAdmin, vous pouvez directement écrire la requète suivante :

    DELETE FROM wp_comments WHERE comment_approved=0

  6. April 27th, 2009 at 21:12 | #6

    useful tutorial. thank you.

  7. Dan Kreimer
    May 6th, 2009 at 15:13 | #7

    Hi there: Great tutorials!
    How do we mass delete Tags and Categories through phpmyadmin, please?
    Thank you

  8. May 6th, 2009 at 15:41 | #8

    @Dan Kreimer: I haven’t looked at doing this directly in the database, but if you use WP 2.7, then you can do this directly in the WP admin area.

  9. Daniel Kreimer
    May 11th, 2009 at 09:29 | #9

    @figaro
    Any idea where I can find and mass delete posts, tags, categories from
    Phpmyadmin, instead of doing it the regular way in wp dashboard please?

    That would save me lots of time!
    Thank you

  10. May 12th, 2009 at 07:18 | #10

    @Daniel: I haven’t looked at doing this, but it shouldn’t be difficult. If you are using 2.7 or later, then you can do this pretty easy in the wp admin as well.

  11. May 24th, 2009 at 15:43 | #11

    THANK YOU so, so much for his helpful tutorial. This is exactly what I needed, all in one place – why was my comments table so big, and how can I get rid of all those spam rows! I am very grateful.

    […Now, if I could just figure out why, since I moderated the comments as spam, they got saved in the database in the first place?…]

  12. July 8th, 2009 at 09:36 | #12

    Just a quick note to thank you for the tutorial. My blog had about 7,000 spam comments because I didn’t realize Akismet was deactivated. I followed your steps on a split screen and took care of it all by the time the video was done.

  13. Sonja
    July 30th, 2009 at 11:03 | #13

    it’s so easy – thanks! with WHERE comment_type = ‘trackback’ i was able to delete the trackback spam, 8000 rows.., (unfortunately comment_approved where 1 in every case)… i was able to create filter on my own. so – never forget to install spam plugins.

  14. August 17th, 2009 at 18:36 | #14

    How do we mass delete Tags and Categories through phpmyadmin, please?

  15. September 5th, 2009 at 15:29 | #15

    the video really helped, thanks

  16. Dave Holmes
    December 6th, 2009 at 16:13 | #16

    Ah thanks I was going to use hypnosis as a last resort

  17. December 15th, 2009 at 17:59 | #17

    THANK YOU! Excellent concise how-to video. Truly appreciated (-: I am curious as to the software you use for the how-to. Could you email me? I have no idea what I would use it for…but I’d love to know and find a use. Also, curious did you produce this great how-to top to bottom with no editing!? Curious…but MOSTLY thankful!!!

  18. December 15th, 2009 at 18:16 | #18

    @HL: I use Camtasia. I did produce it top-to-bottom, but I probably did have to do a bit of editing…I’ve done literally hundreds of videos and I’m rarely perfect…usually need to at least cut out a few coughs, Ah’s, Umm’s, and various mistakes.

  19. January 4th, 2010 at 10:32 | #19

    The perfect tutorial for my problem. Thank you for taking the time to create it.

  20. January 4th, 2010 at 12:08 | #20

    @jonnie jensen: You’re welcome.

  21. Jason
    January 7th, 2010 at 01:09 | #21

    Thank you. I had over 70,000 unwanted comments. Your tutorial helped me out tremendously.

  22. andrea
    January 11th, 2010 at 16:33 | #22

    Very useful – many thanks for your video, really helped me out with one of my sites. :-)

  23. January 16th, 2010 at 23:38 | #23

    Thanks a bunch. I had accidentally disabled askimet and had over 1200 comments I needed to delete. Your video was a major time saver.

  24. January 30th, 2010 at 13:03 | #24

    Thanks for this nice tuto, very helpful and pretty easy to follow, bookmarked :)

  25. November 14th, 2010 at 14:09 | #25

    Thanks very much for that useful tutorial! I was looking for a solution for hours to delete 422 comments unexpected because Askimet was also disabled…

  26. January 25th, 2011 at 11:41 | #26

    THANK YOU!! for helping me quickly delete 3000+ spam comments

  27. July 10th, 2011 at 16:40 | #27

    Thanks for this tutorial. Very helpful indeed.
    Sharon

  28. keppy
    September 21st, 2013 at 15:02 | #28

    Hi, I don’t know much about wordpress. Our website was set up by “a professional”. So I apologize for my ignorance. How do I get to the C Panel or to php.myadmin in order to remove the unwanted comments. Or is there some other way of deleting the unwanted comments. As you said to back up , I am a little worried about this.

    Thanks

  29. October 16th, 2013 at 05:14 | #29

    Really useful tutorial. Got a massive SPAM attack resulting in over 14K unwanted comments. Mine were placed in folder thm_comments and had to run the operation twice using both 0 and 1 for values: DELETE FROM thm_comments WHERE comment_approved=0 and DELETE FROM thm_comments WHERE comment_approved=1. totalling >28K (!) rows. All cleaned up now. Tx!

  1. April 3rd, 2009 at 15:59 | #1
  2. April 27th, 2009 at 21:24 | #2
  3. July 30th, 2009 at 02:13 | #3
  4. September 2nd, 2009 at 18:21 | #4
  5. May 11th, 2010 at 21:00 | #5
  6. August 5th, 2010 at 21:46 | #6
*