RE: REGEX

[Rudy Metzger]

Could you maybe send us your table definition, some example data and an
expected output? 

/rudy

-----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 |
symbol. 
Like this...

a|b|c|d|e

What I need to do is build a list of distinct values between each pipe,
so 
that I get 5 arrays of values, one array for each of the drop-down boxes
I 
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
CEO
GRAFX Group, Inc.
949.433.3641
http://www.gfx.com
http://www.aimprojects.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=1