[lug] OT - MySQL IN() limit

[Zan Lynx]

John Starkey wrote:
> Does anyone know the limit for the mysql IN() function? How many 
> integers it would allow before croaking?

AFAIK, IN generally works by creating an invisible TEMP table with the 
values. It should be limited only by the length of the allowed SQL 
statement.

If you do hit some limit, you can create an explicit TEMP table with the 
values and JOIN against that.

But I do mostly Postgres, so I may not know as much about MySQL as I think.

-- 
Zan Lynx
zlynx at acm.org

"Knowledge is Power.  Power Corrupts.  Study Hard.  Be Evil."