Mysql - How to filter valid emails from database, How to search valid emails from mysql database

How to filter valid emails from database

There are other methods to find whether a mail-id is a valid mail id or not. It is always better to make the check and add mail id into database, but however if you can filter the valid email ids from below mysql query

Mysql query to filter emails from database

 select * from student where `email` NOT REGEXP \'^[A-Z0-9._%-]+@[A-Z0-9.-]+.[A-Z]{2,4}$\'

The topic on Mysql - How to filter valid emails from database is posted by - Math

Hope you have enjoyed, Mysql - How to filter valid emails from databaseThanks for your time