Deleting large numbers of comments from Drupal

• You can easily delete all comments with:

DELETE FROM comments;

• The problem comes when there are good and bad comments, and you only want to get the bad comments. -The cleanest way is to delete all the rogue users first. That will set the UID on their comments to 0, so you can delete all their comments by running:

DELETE FROM comments WHERE uid=0;