MySQL Forums :: Transactions :: maintain result set order with WHERE IN clause

Hi Jesse,

An option is:

SELECT * FROM tbl_name WHERE column_a IN ( val1, val2, val3 )
ORDER BY column_a = val1 DESC, column_a = val2 DESC, column_a = val3 DESC;

Or

SELECT * FROM tbl_name WHERE column_a IN ( val1, val2, val3 )
ORDER BY FIELD(column_a, val1, val2, val3);

Edited 1 time(s). Last edit at 05/23/2008 08:50PM by William Chiquito.