Pending links, Spam links, or Trash links with a WordPress powered blog can grow really quickly and most is spam. Word Press allows you to remove such comments but only 20 at a time. What if you have thousands pending links, spam links or trash links need to be deleted? You will wast a lot time if you delete them via WordPress Blog own functions. Here we will teach you how to delete them via phpmyadmin!
If you login to your hosting panel, access phpadmin, access your database, click SQL,
1. input the below command click ok, all pending comments will be removed.
DELETE FROM wp_comments WHERE comment_approved = ‘0’;
2. input the below command click ok, all spam comments will be removed.
DELETE FROM wp_comments WHERE comment_approved = ‘spam’;
3. input the below command click ok, all trash comments will be removed.
DELETE FROM wp_comments WHERE comment_approved = ‘trash’;