Posted by axlq on 09/11/07 22:06

In article <46e64fd4$0$31120$6e1ede2f@read.cnntp.org>,
gosha bine <stereofrog@gmail.com> wrote:
>
>you can use mysql regular expressions, e.g.
>
>select * from users where email rlike 'user([+][^@]+)?@example[.]com'

Cool. That's just what I wanted to know. I feared the answer would
involve something inefficient like reading in the entire column and
processing it in php.

>or, if you need this query often create an extra "canonical email"
>column in the database.

I was thinking of that solution too, but adding a redundant column,
didn't seem as elegant as constructing a query to work with what I
have.

-A

[Back to original message]