[PHP-DB] query to check valid emails

[Noah Spitzer-Williams]

what's the LIKE query to see if an email address is valid?

For example, in PHP it's something like
    if
(eregi("^[0-9a-z]([-_.]?[0-9a-z])*@[0-9a-z]([-.]?[0-9a-z])*\\.[a-z]{2,3}$",$
email,$check)) {
        echo "valid";
    }


i want to sort through rows in a db and look for invalid email addresses

so like, select * from tbl where email like "???"

Thanks!

- Noah


----------------------------------
TradeMyTraffic! Banner Exchange
http://www.trademytraffic.com





-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]