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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]