From: Daevid Vincent Date: February 17 2005 2:58am Subject: What is the max length of IN() function? List-Archive: http://lists.mysql.com/mysql/180066 Message-Id: <200502170302.j1H32pIg013088@daevid.com> MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit 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?