Re: Find invalid email formats using MySQL query.

Peter Brawley Sat, 20 May 2006 10:13:19 -0700

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&cent;/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

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

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Re: Find invalid email formats using MySQL query.

Reply via email to