[thelist] mysql select brain teaser

[r937]

jeremy, without going into a lot of detail, just create that 5th table

don't ever store multiple values in a single column if you later want to 
"join" to the individual values

that way lies madness, and insanely inefficient code of one sort or another

(if you think generating another SELECT statement from the values and 
running it in a loop is complicated, you oughta see the SQL to accomplish it 
all in one query)

;o)