Re: No Sort Order?

[Felix Geerinckx]

Fraser Murrell wrote:

> SELECT category, title, pubdate
> FROM ds
> WHERE category = 3 OR category = 5 OR category = 4 OR
> category = 101 OR category = 7
>
> I want the result set to return the results in the order that I have queried above (ie: 3,5,4,101,7)

SELECT category, title, pubdate
FROM ds
WHERE category IN (2, 5, 4, 101, 7)
ORDER BY CASE category
WHEN 3 THEN 10
WHEN 5 THEN 20
WHEN 4 THEN 30
WHEN 101 THEN 40
WHEN 7 THEN 50
ELSE 999
END

--
felix
Please use BBCode to format your messages in this forum.