FInd invalid email address

Question

How to find invalid email address in a row with SELECT ?

Answer 1

SELECT
    email
FROM
    TABLE
WHERE
    email NOT LIKE '%_@_%._%'
AND email NOT LIKE '%list of invalid char%';