CODE EXAMPLE FOR SQL

mysql where in keep order

SELECT *
FROM t
WHERE id IN(7,4,9,5,1)
ORDER BY FIELD(id,7,4,9,5,1));