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
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
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