List:General Discussion« Previous MessageNext Message »
From:Rudy Metzger Date:July 10 2003 10:06am
Subject:RE: REGEX
View as plain text  
Could you maybe send us your table definition, some example data and an
expected output? 


-----Original Message-----
From: Doug Wolfgram [mailto:doug@stripped] 
Sent: donderdag 10 juli 2003 4:53
To: mysql@stripped
Subject: REGEX

I am familiar with regex in general, but here is what I want to do...

I have a field that contains 6 actual data items separated by the |
Like this...


What I need to do is build a list of distinct values between each pipe,
that I get 5 arrays of values, one array for each of the drop-down boxes
want to create.

The select statement I need needs to say...

Give me a distinct entries matching any character up to the first | 
character. Or between the first and second |char, etc.

Is there a way to do this with regex?


"Interactive Media that WORKS."

Doug Wolfgram
GRAFX Group, Inc.

MySQL General Mailing List
For list archives:
To unsubscribe:

REGEXDoug Wolfgram10 Jul
RE: REGEXRudy Metzger10 Jul