title: Android SQLiteStatement and UPDATE SET... WHERE IN (1,2,3)
body: <p>I wanted to execute the following SQL statement:</p>
  
  <pre><code>UPDATE X SET y=10 WHERE z IN (1,2,3,4);
  </code></pre>
  
  <p>As the set can contain any number of elements, I created the following SQL string statement:</p>
  
  <pre><code>UPDATE X SET y=? WHERE z IN (?);
  </code></pre>
  
  <p>Next I nicely precompiled it and used <code>SQLiteStatement</code> class for bidning parameters in the following way:</p>
  
  <pre><code>statement.bindLong(1, myLong);
  statement.bindString(2, "1,2,3,4");
  statement.executeUpdateDelete();
  </code></pre>
  
  <p>I hoped naively it will work. No way. If there is only one value as second parameter,ex.</p>
  
  <pre><code> statement.bindString(2, "1");
  </code></pre>
  
  <p>it works then. Otherwise no chance.</p>
  
  <p>Isn't it some kind of bug? Any other proposal how to do in in elegant way? Sure I can put directly the values into String statement:</p>
  
  <pre><code>UPDATE X SET y=? WHERE z IN (?);
  </code></pre>
  
  <p>but then precompilation is not possible. :(</p>