How to Mass Delete Wordpress Comments using Mysql ?

Status
Not open for further replies.

Tommy

Moderator
Joined
Sep 28, 2012
Messages
370
Points
43
Hi everyone,

How to Mass Delete Wordpress Comments using Mysql in PhpMyadmin ?

Thanks
 

wms

Administrator
Staff member
Joined
Jul 7, 2012
Messages
848
Points
63
Login to your Cpanel, go to phpMyadmin, select your database you want remove wordpress comments unapproved
at SQL command run
Code:
DELETE FROM wp_comments WHERE comment_approved = 0
You deleted unapproved comments from wordPress using phpMyAdmin.
Good luck!
 

Jack London

New member
Joined
Jul 9, 2012
Messages
386
Points
0
Thanks for your good tips. It's very efficient to mass delete spam comments in wordpress. I tried and It worked well.
 

jdunhin

New member
Joined
Feb 27, 2013
Messages
93
Points
0
I know you talk about comments but want add that I start using Captha on all my forms. It really help me allot. Maybe a plugin to add it to comments? Or aksimet is not doing his job :)
 
Status
Not open for further replies.
Newer threads
Replies
9
Views
5,043
Replies
6
Views
5,452
Replies
0
Views
6,297
Latest threads
Recommended threads
Replies
5
Views
2,723
Replies
11
Views
6,337
Replies
0
Views
1,308
Replies
3
Views
1,662
Replies
2
Views
2,017

Latest postsNew threads

Referral contests

Referral link for :

Sponsors

Popular tags

You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.

Top