How to Mass Delete Wordpress Comments using Mysql ?

Tommy · Jan 24, 2013

Hi everyone,

How to Mass Delete Wordpress Comments using Mysql in PhpMyadmin ?

Thanks

SEO · Jan 24, 2013

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 · Mar 6, 2013

Thanks for your good tips. It's very efficient to mass delete spam comments in wordpress. I tried and It worked well.

jdunhin · Mar 8, 2013

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

How to Mass Delete Wordpress Comments using Mysql ?

Tommy

Moderator

SEO

Member

Jack London

Well-known member

jdunhin

Active member

Latest posts New threads

Latest posts

New threads

Latest Hosting Offers New Reviews

Latest hosting offers

Popular Contributors - Past 30 Days

Sponsors

Tag Cloud