Just use a placeholder like (??) and flatten everything out. Translate (??) and ...

mappu · on Nov 2, 2014

Then what do you do if the passed tuple has zero length?

Dynamically rewriting the SQL isn't going to be tractable in all cases - doing `IN (NULL)` might be a valid value - and throwing an exception is poor form for an actually valid case.

SapphireSun · on Nov 5, 2014

Check for bad inputs? I'm not saying this is a cure all, but it's a lot better than not being able to use arrays at all.

jiggy2011 · on Nov 1, 2014

I don't think PDO supports this AFAIK.

SapphireSun · on Nov 5, 2014

I had to implement it manually, but it works. FWIW, I'm using a custom wrapper around MySQLi though.