RE: FIND_IN_SET question

2006-11-27 Thread Jerry Schwartz
TECTED] > Sent: Saturday, November 25, 2006 7:47 AM > To: mysql@lists.mysql.com > Subject: FIND_IN_SET question > > hi all, > > this is what i got: > > SELECT find_in_set( box, '2,3,4,5,6,12' ) <1 AS YESNO, box > FROM f2g_booking > ORDER BY box > > wh

Re: FIND_IN_SET question

2006-11-26 Thread Visolve DB Team
Message - From: "Lars Schwarz" <[EMAIL PROTECTED]> To: Sent: Saturday, November 25, 2006 6:17 PM Subject: FIND_IN_SET question hi all, this is what i got: SELECT find_in_set( box, '2,3,4,5,6,12' ) <1 AS YESNO, box FROM f2g_booking ORDER BY box what i need is t

FIND_IN_SET question

2006-11-25 Thread Lars Schwarz
hi all, this is what i got: SELECT find_in_set( box, '2,3,4,5,6,12' ) <1 AS YESNO, box FROM f2g_booking ORDER BY box what i need is those values that haven't been found from the find_in_set list. f2g_booking holds box values of 1,2,4,5,12, that means that are no entries with 3 and 6 in the tabl