|
|
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
Navigation:
[Reply to this message]
|