Check emails in a mysql table column

SELECT * FROM users WHERE email NOT REGEXP '^[^@]+@[^@]+.[^@]{2,}$';

can be used.