mysql ORDER BY based on IN clause
Posted on 2011-02-18
I want to ORDER my sql query based on the IN clause
select * from acct where acct_num in (200,100,150) order by (200,100,150)
My result is ordered by
I assume because acct_num is an index.
I want my resulting order to be