List:General Discussion« Previous MessageNext Message »
From:Peter Brawley Date:May 20 2006 5:12pm
Subject:Re: Find invalid email formats using MySQL query.
View as plain text  
Yesmin Patwary wrote:
> Dear All,
>    
>   My contact table has email field which contains many invalid email addresses. I
> find them using following php function.  Is there a way to do that check in MySQL query?
>    
>   function emailValidate ($str)
>  {
>     $reg = "^([a-zA-Z0-9._-]+)@([a-zA-Z0-9-])+(\.[a-zA-Z0-9-]+)+$";
>     if (eregi($reg, $str)) {
>          return true;//-- good email
>      }else{
>          return false;//--bad email
>      }
>   }//--close function
>   
Works if you change \. to [.period.].

PB

-----
>   Thanks in advance for any comments or help.
>
> 		
> ---------------------------------
> Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls.  Great rates starting
> at 1¢/min.
>   
> ------------------------------------------------------------------------
>
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.392 / Virus Database: 268.6.1/344 - Release Date: 5/19/2006
>   

Attachment: [text/html]
No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.392 / Virus Database: 268.6.1/344 - Release Date: 5/19/2006
Thread
Find invalid email formats using MySQL query.Yesmin Patwary20 May
  • Re: Find invalid email formats using MySQL query.Keith Roberts20 May
  • Re: Find invalid email formats using MySQL query.Peter Brawley20 May
  • RE: Find invalid email formats using MySQL query.fbsd20 May
    • RE: Find invalid email formats using MySQL query.Keith Roberts20 May
      • RE: Find invalid email formats using MySQL query.Chris Sansom21 May