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,214
galaxytext
Julzwriter
What is the difference between an SEO expert and an Internet Marketer?
Replies
14
Views
7,049
JakePeter
vinpay
How to make money online with forum ?
Replies
1
Views
2,790
Julzwriter
pramod
  • Poll
Why to Develop A Website?
Replies
4
Views
2,835
BlackWoods
Novakin
Website Feedback !
Replies
11
Views
5,965
coffeeguy
Newer Threads
K
WTS Are you paying for multiple internet marketing tools?. Stop wasting money!
Replies
1
Views
2,859
brad
W
WTS WTS PR 2+ for all niches
Replies
6
Views
5,555
cheryl smith
vinpay
WTB Need A Forum Template Designer
Replies
0
Views
4,137
vinpay
Jack London
How to promote website via mobile marketing ?
Replies
0
Views
2,003
Jack London
DavidLux
Have you ever made money online ?
2 3
Replies
50
Views
18,282
Diosa
Latest Threads
J
Jtti April promotion, 40% off on Hong Kong cluster servers/US cluster servers, minimum monthly payment starts at $218.6
Replies
0
Views
134
jtti
DemoTiger
How plans of big giants affect web hosting providers like you.
Replies
1
Views
197
BlueLeaf
M
Mobile App
Replies
0
Views
259
masterkind
AlpineHost
Trouble with Stripe webhook endpoint
Replies
1
Views
363
AlbaHost
viseo
Anyone for free WordPress hosting?
Replies
2
Views
255
BlueLeaf
Recommended Threads
lkovnih226
Link Juice and Outbound Links?
Replies
6
Views
2,662
MilesWeb
BillEssley
Free or Paid SSL Certificate Services?
Replies
10
Views
5,631
johnnymorgan
KevinHV
SELLING HOSTVENTO PURE SSD KVM VPS - Fully Managed / cPanel / WHMCS / WHM / R1Soft & LetsEncrypt
Replies
3
Views
2,330
Cheerag Nundlall
Marc0
How To Succeed Marketing on Facebook
Replies
1
Views
2,342
pixelfire
MotionGrafika
How to find POP3, SMTP and IMAP Ports
Replies
10
Views
5,064
AlphaNine Vini
Similar Threads
fiz
Mass/Bulk Promo Codes - WHMCS Addon [Paid]
Replies
0
Views
990
fiz
S
Hosting for mass video upload ?
Replies
1
Views
1,431
24x7CSM
norled
UNLIMITED Web Hosting with Massive 70% Discounts - Instant Setup From Only $1/mth - Bytemeup.com
Replies
4
Views
3,236
digitallakshay
kevinhng86
PERL - Mass A Record IPv4 to IPv6 Replacement
Replies
0
Views
2,495
kevinhng86
wpspeedster
What are hosting servers allowing mass/bulk emailing with no sending limits (500,000+ emails)?
Replies
8
Views
3,426
SisterMachineGun

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