[thelist] mysql select brain teaser

r937 rudy at r937.com
Fri Nov 21 06:21:31 CST 2008

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)


More information about the thelist mailing list