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: 280
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
