Re: [PHP-DB] query to check valid emails
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 - 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]
Re: [PHP-DB] query to check valid emails
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]
Re: [PHP-DB] 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 <[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]