How to bulk delete all unapproved comments in Drupal?
Do you have the problem of thousands of spam comments building up on your Drupal site? Ok, the best solution is to check it regularly and delete the unwanted comments, and just leaving the appropriate ones. However, what if you forget to look at your comments for a few days, if you go on holiday for a week and don’t check your blog or your site has been attacked? You can delete these comments manually but this is time consuming (Drupal admin interface only shows you a list of 25 items). This method will allow you to delete all the unapproved comments and leaves the approved ones intact.