How to use an IN clause in iBATIS?

Posted by furtelwart on Stack Overflow See other posts from Stack Overflow or by furtelwart
Published on 2009-10-28T14:59:06Z Indexed on 2010/04/29 20:17 UTC
Read the original article Hit count: 275

Filed under:
|
|

I'm using iBATIS to create select statements. Now I would like to implement the following SQL statement with iBATIS:

SELECT * FROM table WHERE col1 IN ('value1', 'value2');

With the following approach, the statement is not prepared correctly and no result returns:

SELECT * FROM table WHERE col1 IN #listOfValues#;

iBATIS seems to restructure this list and tries to interpret it as a string.

How can I use the IN clause correctly?

© Stack Overflow or respective owner

Related posts about ibatis

Related posts about sql