mysql - MY Sql IN Query in where Clause gives one rows as output -

this query returns single row

set @id='2,3,4,5,6,7,8,9'; set @typers=1; select * employee (@typers=1 , pkempid in (@id)); 

if directly assign 2,3,4,5,6,7,8,9 in in query works know because of " ' ".

but m getting same issue when pass values parameter in procedure

call calculatestandardfinalrun('0','4','1900-01-01 00:00:00','1900-01-01 00:00:00','5','1','2,3,4,5,6,7,8,9'); 

how can values

i think should try 1

select * employee (@typers=1 , find_in_set(pkempid, @id)));