> -----Original Message----- > From: Daevid Vincent > Sent: Wednesday, February 16, 2005 20:59 > To: mysql@lists.mysql.com > 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
