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:
mysql, delete, items, howtodelete, wp_comments, comment_author_email, user, hotmail, subquery,