Hi,
Hope, a string constant can be searched against a column; Most of the
string function including find_in_set, allows us to display only the table
values and not the string constants passed.
Try it with 2 tables; or some userdefined functions.
Thanks
ViSolve DB Team.
----- Original 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 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]
