title: Preserve order of results with WHERE IN with jOOQ
body: <p>The issue has already been described in detail in <a href="https://stackoverflow.com/questions/866465/order-by-the-in-value-list">ORDER BY the IN value list</a>,</p>
  <p>but to repeat: I want to select items with ids 1,3,2,4 in that specific order.</p>
  <p>My jOOQ snippet:</p>
  <pre><code>var results = create.select().from(ITEM).where(ITEM.ID.in(1,3,2,4)).fetchInto(Item.class);
  </code></pre>
  <p>The resulting <code>results</code> list will have items in order of 1,2,3,4.
  How can I preserve the order of the items with jOOQ?</p>