How to Mass Delete Unapproved WordPress Comments
How to Mass Delete Unapproved Comments from Your WordPress Database Using phpMyAdmin
How to Mass Delete Unapproved Comments from Your WordPress Database Using phpMyAdmin
Related posts:
This site is optimized for display on your iPhone
Bigdump
Blackboard
Canvas
Change URL
Custom header
Database
Edit theme
From WordPress Codex
Google
iNove
Install
Instructure
Kubrick
lms
Localhost
Locked out of WP
Manage comments
Moodle
moodle 2.0
Moodle Partner
moodle security
moodle upgrade
Move
MS Excel
Multiple Blogs
Non-Techie
phpMyAdmin
Released Under GPL
Security
Upgrade
wordpress
wordpress.org moderation
WordPress 2.8
WordPress 2.8 Users Guide
WordPress 2.9
WordPress 3.0
WordPress Post
wordpress security
WordPress Themes
WordPress Training
wordpress upgrade
WordPress User's Guide
WP Plugins
WP Themes
XAMPP From WordPress Codex — GPL (15)
Image Editing (3)
Install WP (5)
Just the Video Tutorials (33)
LMS (2)
Locked out of WP (5)
Moodle (92)
Move WP (6)
MS Office (2)
MySql DB (2)
Non-Techie (4)
Quotable Tweets (5)
Twitter (2)
Uncategorized (23)
Upgrade WP (5)
WordPress Mu (2)
WordPress Termonology (1)
WordPress Users Guides (3)
WP 2.9 (5)
WP 3.0 (7)
WP Comments (2)
WP database (5)
WP General (20)
WP Mobile (1)
WP Older (28)
WP Plugins (9)
WP Templates (2)
WP Themes (14)
XAMPP (4)
WP Cumulus Flash tag cloud by Roy Tanck and Luke Morton requires Flash Player 9 or better.
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?
Thank you for this great tutorial!
Deleted rows: 53622 (Query took 12.2305 sec)
THANK YOU!
Great tutorial. Thanks so much.
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
useful tutorial. thank you.
Hi there: Great tutorials!
How do we mass delete Tags and Categories through phpmyadmin, please?
Thank you
@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.
@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
@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.
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?...]
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.
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.
How do we mass delete Tags and Categories through phpmyadmin, please?
the video really helped, thanks
Ah thanks I was going to use hypnosis as a last resort
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!!!
@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.
The perfect tutorial for my problem. Thank you for taking the time to create it.
@jonnie jensen: You’re welcome.
Thank you. I had over 70,000 unwanted comments. Your tutorial helped me out tremendously.
Very useful – many thanks for your video, really helped me out with one of my sites.
Thanks a bunch. I had accidentally disabled askimet and had over 1200 comments I needed to delete. Your video was a major time saver.
Thanks for this nice tuto, very helpful and pretty easy to follow, bookmarked
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…
THANK YOU!! for helping me quickly delete 3000+ spam comments
Thanks for this tutorial. Very helpful indeed.
Sharon