How to Mass Delete Wordpress Comments using Mysql ?

[Tommy]

Hi everyone,

How to Mass Delete Wordpress Comments using Mysql in PhpMyadmin ?

Thanks

 

[wms]

Login to your Cpanel, go to phpMyadmin, select your database you want remove wordpress comments unapproved
at SQL command run

DELETE FROM wp_comments WHERE comment_approved = 0

You deleted unapproved comments from wordPress using phpMyAdmin.
Good luck!

 

[Jack London]

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

 

[jdunhin]

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