Very big IN ( $value )

[Batara Kesuma]

Hi,

I do my query from Perl DBI, it has a very big IN ( $value ).
The query looks like:
SELECT id FROM user 
WHERE sex='m' 
AND hobby_id='3'
AND id IN ( $value );

$value looks like:
102, 233, 445, 543 ... 3443, 332 very long list.

It might be about 10,000 id in $value. What is the maximum value I can
pass in a query? Is this the right way to do it? (I mean, using a very
big value inside IN)

Thank you,
--bk