Re: ORDER records based on parameters in IN clause

On Wed, 2005-06-29 at 09:22, Russell Simpkins wrote:
> fair enough. but a simple order by id would never work.
> 

Try this:

select     *,case     when id=2003 then 1     when id=1342 then 2     when id=799 then 3     when id=1450 then 4 end as
ob
 
from tablename 
where id in (2003,1342,799,1450) 
order by ob;