Re: query to check valid emails

select * from tbl where email like "%$email%"; This will find the string stored in the variable '$email' in the column 'email' Adjust having the '%' at the end, the beginning or both (as above) as they will find the string '$email' at end or at the beginning of the string stored in the column 'email' respectively. Russ On Sat, 24 Nov 2001 13:06:50 -0500 Noah Spitzer-Williams <noahsw@cyberdude.com> wrote: > 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: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > #-------------------------------------------------------# "Believe nothing - consider everything" Russ Michell Anglia Polytechnic University Webteam Room 1C 'The Eastings' East Road, Cambridge e: r.j.michell@apu.ac.uk w: www.apu.ac.uk/webteam www.theruss.com #-------------------------------------------------------#