MySQL DELETE all but specific items or records howto
DELETE FROM `wp_comments` WHERE NOT comment_author_email IN ('user@hotmail.com','another@hotmail.com')
The above is an example of specific records you type out, but you could also base it on a subquery.
Tags: