title: ORDER BY Values especified in clausule "IN()" BUT in Generics SQL and Informix
body: <p>I expect no repeat another question... I can't find the solution. All the solution are for MySql.</p>
  
  <p>I want order the result of my query by the values in the clausule IN. But in internet and stackoverflow just find the solution for "MySql" like here:</p>
  
  <p><a href="https://stackoverflow.com/questions/13416153/order-by-field-in-mysql">Order by FIELD in MYSQL</a></p>
  
  <p><a href="https://stackoverflow.com/questions/14104055/ordering-by-specific-field-value-first">Ordering by specific field value first</a></p>
  
  <p><a href="https://stackoverflow.com/questions/9917829/mysql-order-by-field-with">MySQL ORDER BY FIELD with %</a></p>
  
  <p>Using clausule FIELD or FIELD_IN_SET. Can I use something similar to this.</p>
  
  <p>thanks!!</p>
  
  <hr>
  
  <p>I just try... and it doesn't work. This is my query.</p>
  
  <pre><code>select * from (
      select 4 as dato1 from systables where tabid = 1 union
      select 2 as dato1 from systables where tabid = 1 union
      select 1 as dato1  from systables where tabid = 1 union
      select 3 as dato1  from systables where tabid = 1 
  )
  where dato1 in (4,2,1,3)
  order by instr('4,2,1,3', dato1)
  </code></pre>
  
  <p>This is that the query show:</p>
  
  <pre><code>dato1
  1
  2
  4
  3
  </code></pre>
  
  <p>I don't undertand...</p>