SELECT * 
  FROM (SELECT 'mike.iron@gmail.com' AS email UNION SELECT 'marek.aureliusz@gmail.com' AS email UNION SELECT 'roman.polonius' AS email) AS q
 WHERE q.email
  LIKE '%[A-Z0-9][@][A-Z0-9]%[.][A-Z0-9]%'