I have a quick SQL question that I hope someone can answer,
I have two tables
Events { e_id int(11), e_name varchar(200) };
Bookings { customer varchar(200), event_list varchar(200) };
Event_list is a string of comma separated values, eg "1,2,4" where the
number corresponds to Events.e_id
Sample data: Events { {1,'one'}, {2,'two'}, {3,'three'} }
Booking { {'john','1,3'} , {'jane','2,3'} }
I would like some query that will return 2 rows
John, 'one, three'
Jane, 'two,three'
Is this possible ?
I inherited the schema and the data, so I would prefer not having to
refactor anything, unless I have to.
Thanks in Advance,
Neal
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
