title: Android Sqlite IN, NOT IN syntax
body: <p>I'm trying to run <code>NOT IN</code> select where <code>NOT IN</code> list is dynamic. Something like</p>
  
  <pre><code>SELECT id, type FROM CONTACTS where type NOT IN ('connect','answer')
  </code></pre>
  
  <p>In the code my futile attempts were:</p>
  
  <pre><code>db.query(TABLE, new String[] { "id", ""}, " type NOT IN (?)", "connect,answer", 
      null, null, null); // didn't work
  db.query(TABLE, new String[] { "id", ""}, " type NOT IN (?)", "'connect','answer'", 
  null, null, null); // didn't work
  </code></pre>
  
  <p>My take on this is that <code>?</code> substitution treats my comma list as single argument. I did find a solution but it is rather ugly so I won't post it here until someone comes forward with something more elegant</p>