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:Code:delete from comments where status = '1';
Code:delete from comments where status = '0';
Submit Your Webmaster Related Sites to the NB Directory
I swear, by my life and my love of it, that I will never live for the sake of another man, nor ask another man to live for mine.