How to Mass Delete Wordpress Comments using Mysql ?

Tommy

Tommy

Moderator
Staff Member
Joined
Sep 28, 2012
Messages
189
Points
28
Hi everyone,

How to Mass Delete Wordpress Comments using Mysql in PhpMyadmin ?

Thanks
 
SEO

SEO

Member
Registered
Joined
Jul 7, 2012
Messages
20
Points
0
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

Jack London

Well-known member
Joined
Jul 9, 2012
Messages
158
Points
18
Thanks for your good tips. It's very efficient to mass delete spam comments in wordpress. I tried and It worked well.
 
jdunhin

jdunhin

Active member
Registered
Joined
Feb 27, 2013
Messages
72
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 :)
 
You must log in or register to reply here.
Older Threads
G
Can Mobile marketing assist you reach Your Mobile advertising campaign?
Replies
0
Views
2,445
galaxytext
Julzwriter
What is the difference between an SEO expert and an Internet Marketer?
Replies
14
Views
7,732
JakePeter
vinpay
How to make money online with forum ?
Replies
1
Views
2,962
Julzwriter
pramod
  • Poll
Why to Develop A Website?
Replies
4
Views
3,032
BlackWoods
Novakin
Website Feedback !
Replies
11
Views
6,475
coffeeguy
Newer Threads
K
WTS Are you paying for multiple internet marketing tools?. Stop wasting money!
Replies
1
Views
2,995
brad
W
WTS WTS PR 2+ for all niches
Replies
6
Views
5,860
cheryl smith
vinpay
WTB Need A Forum Template Designer
Replies
0
Views
4,302
vinpay
Jack London
How to promote website via mobile marketing ?
Replies
0
Views
2,143
Jack London
DavidLux
Have you ever made money online ?
2 3
Replies
50
Views
19,539
Diosa
Latest Threads
J
Jtti Black Friday flash sale: 80% off annual payment for unlimited cloud servers, starting at $24.62/year, 2C2G in Hong Kong as low as $4.3/month
Replies
0
Views
31
jtti
Emily Routledge
Best Laptop recommendations for Work and Casual Gaming around $1000?
Replies
0
Views
87
Emily Routledge
Tinyservers.eu
Affordable Dedicated Servers - Raspberry Pi & Intel N95 | From €12.90/mo - Unlimited Traffic.
Replies
2
Views
66
Tinyservers.eu
N
Looking for a dedicated server in the EU/US with specific specs. Any advice for good websites?
Replies
1
Views
108
AlbaHost
R
What’s the Real Difference Between Web Design and Development for Growing Businesses?
Replies
1
Views
103
Emily Routledge
Recommended Threads
LeatherCrafting
Reseller Hosting
Replies
10
Views
5,107
AlbaHost
David Beroff
What is whoisGuard and should you pay for it?
Replies
17
Views
9,908
MamaSue83
yunarel
Top 3 Mistakes in Web Design
Replies
2
Views
2,639
donaldmedina
tk-hassan
WTS Complete W3C Certified HTML | TEMOK Offers Top Quality Web Design Services | $175 Only
Replies
0
Views
2,108
tk-hassan
acerstoreau
Can a poor design kill your sales?
2 3
Replies
49
Views
11,973
Dr. McKay
Similar Threads
AlpineHost
Struggling to install SpamAssassin in Plesk
Replies
4
Views
889
AlpineHost
J
How does a high-defense cloud server defend against massive traffic attacks?
Replies
3
Views
932
ASQ
fiz
Mass/Bulk Promo Codes - WHMCS Addon [Paid]
Replies
0
Views
1,212
fiz
S
Hosting for mass video upload ?
Replies
1
Views
1,597
24x7CSM
norled
UNLIMITED Web Hosting with Massive 70% Discounts - Instant Setup From Only $1/mth - Bytemeup.com
Replies
4
Views
3,632
digitallakshay

Latest postsNew threads

Latest Hosting OffersNew Reviews

Popular Contributors - Past 30 Days

Sponsors

Tag Cloud

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.
  • cpanel
  • dedicated
  • free
  • hello
  • hosting
  • hosting services
  • marketing
  • offers
  • seo
  • server
  • services
  • vps
  • web
  • web hosting
  • website
  • wordpress
    • Top