Is this one of those places where a HAVING clause is needed? ... HAVING YESNO = 0
Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -----Original Message----- > From: Lars Schwarz [mailto:[EMAIL PROTECTED] > 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 > > 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 table... that's what i need 3 and 6 as a > result, e.g. > those > values from the list that haven't been found (are not in the > table). how to > do > that? thanks: lars > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
