SELECT `email` FROM `users` WHERE `email` NOT REGEXP '[A-Z0-9._%+-]+@[A-Z0-9.-]+\.[A-Z]{2,4}' GROUP BY `email`
As seen here: http://stackoverflow.com/questions/2247266/mysql-valid-unique-e-mail
nonsense ideas
SELECT `email` FROM `users` WHERE `email` NOT REGEXP '[A-Z0-9._%+-]+@[A-Z0-9.-]+\.[A-Z]{2,4}' GROUP BY `email`
As seen here: http://stackoverflow.com/questions/2247266/mysql-valid-unique-e-mail