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
         return false;//--bad email
  }//--close function
Works if you change \. to [.period.].


  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