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