Delete ALL Comments from Drupal
One of our Drupal sites was misconfigured and as a result it received thousands of spammy comments linking to very undesirable neighborhoods.
Using the Drupal GUI to delete these was taking forever.
Going straight to MySQL was a lot quicker.
SQL Command to Delete all Unpublished Comments In Drupal:
As per usual, back up your database before monkeying with SQL directly.
SQL Command to Delete all Published Comments In Drupal:
delete from comments where status = '1';
delete from comments where status = '0';