Posted by Jerry Stuckle on 09/11/07 02:34

axlq wrote:
> I'm trying to figure out a MySQL query expression to match an email
> address. Here's the situation:
>
> User registers on my site with a "plus style" email address
> (username+key@example.com). This is a perfectly legal address and I
> don't want to disallow it, because I use this style myself and find
> it useful. For example user+whatever@gmail.com will get delivered
> to user@gmail.com.
>
> Now, the user forgets his password. He is prompted to enter his
> email address, to which my site will send a temporary password.
>
> Problem: if he enters username@example.com instead of the address
> username+key@example.com that's stored in my database, I should be
> able to find the address. How do I construct a MySQL query to match
> what the user enters with the "plus" address in the database?
>
> The simplest way is to strip the +suffix from the username when the user
> first registers on my site, but I'd rather not do that.
>
> -A

MySQL questions should be asked in comp.databases.mysql. This is a PHP
newsgroup.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]