> -----Original Message-----
> From: Daevid Vincent
> Sent: Wednesday, February 16, 2005 20:59
> To: mysql@stripped
> Subject: What is the max length of IN() function?
>
> I tried to find this function on the dev.mysql.com site, but good luck
> finding "in"... ;-)
>
> Can someone tell me what the maximum length is for this function?
>
> SELECT * FROM foo WHERE bar IN(1,2,3,4,..... N);
>
> How many entries can there be in between 1 and N ? Hundreds?
> Thousands?
> Millions?
From http://dev.mysql.com/doc/mysql/en/comparison-operators.html, "The
number of values in the IN list is only limited by the max_allowed_packet
value."
---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
