Prepared Statements

[Brian Cameros]

Is it possible to bind arrays to a prepared statement? Something like this:

SELECT id, name from blah WHERE id in ?

And then bind a set of ids to that question mark. I'm guessing it's not possible, and so I have a followup question:

Let's say that I have a SQL query, but I've already limited the set of ids to which I want the query applied. If there any way to pass that information into MySQL without building a (string) query like

SELECT id, name from blah WHERE id in (2,5,8,9) etc.

The id set passed into the query could be quite large (1,000s of ids), and I'm not sure I wouldn't overrun a buffer or run into performance problems parsing the SQL string...

Thanks for any help,
Brian