title: Set to Boolean value based on IN clause
body: <p>How can the following be performed in a single query?</p>
  
  <pre><code>UPDATE clients SET online=0 WHERE id NOT IN(4,5,8,10,12) AND id&gt;=2 AND id&lt;=15 AND parentId=123;
  UPDATE clients SET online=1 WHERE id     IN(4,5,8,10,12) AND id&gt;=2 AND id&lt;=15 AND parentId=123;
  </code></pre>