title: SQL/mariadb Select with IN() over mutiple columns in the same order
body: <p>I need a syntax in sql which returns a result in the same order as given in the IN() field.
  The problem is that the primary key consists of two keys.</p>
  <p>So the following does not apply:</p>
  <pre><code>SELECT * FROM table where id IN (4,5,6) ORDER BY FIELD (id,4,5,6);
  </code></pre>
  <p>my table:</p>
  <pre><code>primary(column 1+2)   column 3   column 4   cloumn 5......
      hash | num      |          |          |
  </code></pre>
  <p>Pseudo code for understanding would look like this:</p>
  <pre><code>SELECT * FROM table WHERE (hash,num) IN ([&quot;fjdigjhu&quot;,5],[&quot;fgfjhgaa&quot;,2],...) ORDER BY FIELD ([hash,num],[&quot;fjdigjhu&quot;,5],[&quot;fgfjhgaa&quot;,2],...); 
  </code></pre>