No this will not do what the original poster requested
it will be something like the following
select * from table where email regexp
"^[0-9a-z]([-_.]?[0-9a-z])*@[0-9a-z]([-.]?[0-9a-z])*\\.[a-z]{2,3}$";
Regards
Jon
--
Jon Farmer
Systems Programmer, Entanet www.enta.net
Tel 01952 428969 Mob 07763 620378
PGP Key available, send email with subject: Send PGP Key
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
<[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
#-------------------------------------------------------#
"Believe nothing - consider everything"
Russ Michell
Anglia Polytechnic University Webteam
Room 1C 'The Eastings' East Road, Cambridge
e: [EMAIL PROTECTED]
w: www.apu.ac.uk/webteam
www.theruss.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]
--
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]
