How to use an IN clause in iBATIS?
- by furtelwart
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?
