From: "Batara Kesuma" <[EMAIL PROTECTED]> > 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)
WIth 10,000 items in an IN () condition, my guess is that the list is a result of another query. So either JOIN the two tables and combine the two queries, or create a temporary table (with appropriate indices!) and store the results of the first query in the temporary table. Then you can JOIN these tables on id. I don't know if there is a strict limit on the number of items in an IN() condition, but you will probably hit the limit of the total length of a query. Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]