[prev in list] [next in list] [prev in thread] [next in thread] 

List:       systalk
Subject:    Re: [Systalk]Regular Expression && MySQL
From:       Guenter Hopf <qe1 () gmx ! at>
Date:       2001-02-23 22:49:00
[Download RAW message or body]

hi,

SELECT ..... WHERE name REGEXP "(Dr.)?[:space:]?[A-D].*";
should do the trick
hope this helps

cheers,
guenter

At 11:01 23.02.01 -0500, you wrote:
>What I'm trying to do is create a query for mysql that will match certain 
>entries in a database. I'm guessing REGEXP is the best way to do this but I 
>can't figure it out. I'm trying to match names Starting with [A-D] but they 
>might be preceded by Dr.. 
>
>Match:
>Dr. Crow
>Crow
>Dr. Apple
>
>Not Match:
>Dr. Jackson
>Dr. James
>
>-Thanks David
>
>_________________________________________________________
>Do You Yahoo!?
>Get your free @yahoo.com address at http://mail.yahoo.com
>
>
>_______________________________________________
>DHS Systalk Discussion List Systalk@dhs.org
>To manage your subscription, please goto:
>http://www.dhs.org/mailman/listinfo/systalk
> 
-- 
"Things should be made as simple as possible, not any simpler"
(A. Einstein)

_______________________________________________
DHS Systalk Discussion List Systalk@dhs.org
To manage your subscription, please goto:
http://www.dhs.org/mailman/listinfo/systalk

[prev in list] [next in list] [prev in thread] [next in thread]