SQL/mariadb Select with IN() over mutiple columns in the same order

Question

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.

So the following does not apply:

SELECT * FROM table where id IN (4,5,6) ORDER BY FIELD (id,4,5,6);

my table:

primary(column 1+2)   column 3   column 4   cloumn 5......
    hash | num      |          |          |

Pseudo code for understanding would look like this:

SELECT * FROM table WHERE (hash,num) IN (["fjdigjhu",5],["fgfjhgaa",2],...) ORDER BY FIELD ([hash,num],["fjdigjhu",5],["fgfjhgaa",2],...); 

question from:https://stackoverflow.com/questions/65844269/sql-mariadb-select-with-in-over-mutiple-columns-in-the-same-order

Answer 1

I would suggest a derived table:

SELECT t.*
FROM table t JOIN
     (SELECT 1 as ord, 'fjdigjhu' as hash, 5 as num UNION ALL
      SELECT 2 as ord, 'fgfjhgaa' as hash, 5 as num UNION ALL
      . . . 
     ) x
     USING (hash, num)
ORDER BY x.ord;