How do I parameterize a SQL IN clause?

Question

2

(click on this box to dismiss)

I want to parameterize the arguments in the IN clause. I know how to parameterize the "search" field:

SELECT * FROM tbl WHERE ? IN (1,2,3);

But how can I parameterize the arguments to IN without knowing how many there are?

SELECT * FROM tbl WHERE column IN (?)

only allows one parameter to be passed to execution.

link comment (0)

asked 2 years ago

54

Answer 1

1

In CUBRID, the IN operator is defined as argument IN collection.

To parameterize the whole IN clause you can write:

SELECT * FROM tbl WHERE column IN ?

To parameterize only certain elements of the IN clause you can write:

 SELECT * FROM tbl WHERE column IN (1, ?, 2, ?, ?)

link comment (0)

answered 2 years ago

491

Related Questions