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
