title: How to use an IN clause in iBATIS?
body: <p>I'm using <a href="http://ibatis.apache.org/" rel="noreferrer">iBATIS</a> to create select statements. Now I would like to implement the following SQL statement with iBATIS:</p>
  
  <pre><code>SELECT * FROM table WHERE col1 IN ('value1', 'value2');
  </code></pre>
  
  <p>With the following approach, the statement is not prepared correctly and no result returns:</p>
  
  <pre><code>SELECT * FROM table WHERE col1 IN #listOfValues#;
  </code></pre>
  
  <p>iBATIS seems to restructure this list and tries to interpret it as a string.</p>
  
  <p>How can I use the IN clause correctly?</p>