In query not working

[Cherian Sabby]

Hi everybody,
I have a stored procedure where I do the following

1) DECLARE csv VARCHAR(255);
2) SET csv = '268,484,435';
3) select * from tableX where foreignKeyId in (csv);

Now suppose the table has 10 rows with foreignKeyId 268, 10 rows with foreignKeyId 484 and 5 rows with foreignKeyId 435.

But when I run the stored procedure it just returns me 10 rows with foreignKeyId 268.

I have not been able to figure out why only 10 rows are returned and not 25.
Is there a problem while using the in keyword.

Regards,
Cherian