mysql calling stored procedure for where id in -

i have created stored proc returns 1 column of id's linking.

sql = call myproc(555)

the above works returning result set of id's.

sql = "select * mytable  id in (call myproc(555))"

the above query says syntax incorrect , bombs.

suggestions? glenn

Soju