*Note this will delete all comments indiscriminately.
DELETE FROM `wp_comments`
To delete all but save specific comments based on "author e-mail use the following". Add more e-mails below in the same format if you have more.
DELETE FROM `wp_comments` WHERE NOT comment_author_email IN ('firstname.lastname@example.org','email@example.com')........