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.
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
3 messages in com.mysql.lists.mysqlRe: FIND_IN_SET question
