MySQL check valid email address

Check valid email address in MySQL:
emailaddresses.EmailAddress NOT REGEXP '^[A-Z0-9._%-]+@[A-Z0-9.-]+\.[A-Z]{2,4}$')
Example
 SELECT (CASE WHEN (emailaddresses.EmailAddress NOT REGEXP '^[A-Z0-9._%-]+@[A-Z0-9.-]+\.[A-Z]{2,4}$') AND stakeholders.ComputingID IS NOT NULL THEN
                CONCAT(stakeholders.ComputingID, '@sfu.ca')  ELSE emailaddresses.EmailAddress END) AS EmailAddress
            FROM emailaddresses, stakeholders
            WHERE emailaddresses.Stakeholder_id = stakeholders.Stakeholder_id
            AND stakeholders.Stakeholder_id = 321  LIMIT 1;