: 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
Message -
From: Lars Schwarz [EMAIL PROTECTED]
To: mysql@lists.mysql.com
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 those values
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