Checking similar gmail email ids
Posted: Mon Aug 15, 2011 6:39 pm
Hi Guys,
I am working on an application where we need to have each user input unique email id. Now, the problem is with gmail IDs. In gmail username@gmail is same as user.name@gmail.com which is again same as use.r.name@gmail.com.
Now, how to make sure that only one of a kind of email id is allowed. I am storing the email IDs in the database. Should, I be using a query involving LIKE ? Please suggest.
I am working on an application where we need to have each user input unique email id. Now, the problem is with gmail IDs. In gmail username@gmail is same as user.name@gmail.com which is again same as use.r.name@gmail.com.
Now, how to make sure that only one of a kind of email id is allowed. I am storing the email IDs in the database. Should, I be using a query involving LIKE ? Please suggest.