title: Prepared statements and the IN expression
body: <p>I have a database where users can search for records that have one or more of a list of items. I'm using IN to do the search, but I can't get IN to work with prepared statements. This is what I've tried:</p>
  
  <pre><code>SELECT * FROM tbl1 WHERE col IN (?)
  </code></pre>
  
  <p>But the prepared statement treats the list of items I pass it as a single item. How can I make this work?</p>
  
  <p>I'm using sqlite, if it makes any difference.</p>