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/[EMAIL PROTECTED]
