[RESOLVED] can i use stored array as a condition in the query itself

[hawkeye000]

Hello every body
If i have two tables in mysql database
tbl1 ,tbl2

in tbl1 i have a field id (auto increment), ids
and i insert array of numbers like 5,6,3,8,7,9 in every record in feild ids
like that:
insert into tbl1(ids) values ('5,6,3,8,7,9')

in tbl2 i want to :
SELECT * FROM tbl2 where ID in (SELECT ids from tbl1 where id=$_GET)

please i want to do that in one query

any help

[bradgrafelman]

To see if a particular value is in a set of values, MySQL provides a FIND_IN_SET() function.

[hawkeye000]

thank you
but i do that and still not working
SELECT tbl2. ,tbl1. FROM tbl2,tbl1 where FIND_IN_SET (tbl2.ID,tbl1.ids )
😕

[hawkeye000]

i changed it to
SELECT tbl2. ,tbl1. FROM tbl2,tbl1 where FIND_IN_SET (ID,ids )

and it worked fine .. but why the past query not working???