Find invalid email formats using MySQL query.

[Yesmin Patwary]

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

  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.