Glad someone knows more than I do, or that chap would be right up a certain creek
without a paddle..
Cheers
Russ
On Wed, 28 Nov 2001 09:44:26 -0000 Jon Farmer <[EMAIL PROTECTED]> wrote:
> 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]
>
#-------------------------------------------------------#
"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]
