How to validate email addresses in Mysql?

I order to validate the email addresses in Mysql, below mentaioned query is used –
SELECT * FROM `users` WHERE `email` NOT REGEXP '^[^@]+@[^@]+\.[^@]{2,}$';