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
From: Yesmin Patwary [EMAIL PROTECTED]
Subject: Find invalid email formats using MySQL query.
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
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 =
adding it is the normal way this is
done.
-Original Message-
From: Yesmin Patwary [mailto:[EMAIL PROTECTED]
Sent: Saturday, May 20, 2006 10:48 AM
To: mysql@lists.mysql.com
Subject: Find invalid email formats using MySQL query.
Dear All,
My contact table has email field which contains many
, 20 May 2006, fbsd wrote:
To: Yesmin Patwary [EMAIL PROTECTED], mysql@lists.mysql.com
From: fbsd [EMAIL PROTECTED]
Subject: RE: Find invalid email formats using MySQL query.
You need to use a stronger edit to check email addresses.
This is what I use. Note the dns mx domain name check
At 22:10 +0100 20/5/06, Keith Roberts wrote:
Probably the most efficient place to do this sort of field
checking would be using javascript in the browser. That
would stop the bad addresses even being sent down the line
to the server in the first place.
Sure, but if you're being conscientious