Ordering by where clause?

frigidman

Say I have:

select ENTRYID,OTHERSTUFF from SOMETABLE WHERE ENTRYID IN (20,2,15,8);

Now, how would one go about having it order by the IN order?

Like, spit out 20 first, then 2, then 15, then 8?

As is, the above will spit out the contents in the order as it feels (which is normally the insert order from the start).

Help?
Thanks.

Anon

select ENTRYID,OTHERSTUFF
from SOMETABLE
WHERE ENTRYID IN (20,2,15,8)
order by case entryid
when 20 then 1
when 2 then 2
when 15 then 3
when 8 then 4 end

frigidman

That works out good. Easy to make that case statement from the IN var (gotta love explode and implode).

I dug around on the MySQL docs page, but couldn't seem to find anything as useful for my searches (sometimes I hate their search page).

Thanks!