3 messages in com.mysql.lists.mysqlRE: FIND_IN_SET question
FromSent OnAttachments
Lars Schwarz25 Nov 2006 04:47 
Visolve DB Team26 Nov 2006 22:29 
Jerry Schwartz27 Nov 2006 10:38 
Subject:RE: FIND_IN_SET question
From:Jerry Schwartz (jsch@the-infoshop.com)
Date:11/27/2006 10:38:53 AM
List:com.mysql.lists.mysql

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:lars@gmail.com] Sent: Saturday, November 25, 2006 7:47 AM To: mys@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