So today I logged on to one of the Clients WordPress and they told me that their site had been infested with Spam Comments over 3000 to be exact!
So i login to wordpress backend and try deleting them batch by batch! Gave up after few mins because it takes soo much time
this is where MYSQL Query comes handy!
Login to PHPmyadmin
Choose the WordPress Database
and run these queries
DELETE FROM `wp_comments` WHERE `comment_approved`=’spam’
DELETE FROM `wp_comments` WHERE `comment_approved`=’0′
Took 3 seconds! And all vanished!
So heres a tip incase you get filled with Spam!