Order problem

sidsel

My table:

itemid | desc

Query:
SELECT desc FROM table WHERE itemid = 1000 OR itemid = 5000 OR itemid = 3000

The rows are returned in the order they are in the table but I want the rows returned in the order specified in the query. How can I fix this?

NogDog

You need an ORDER BY clause in your query if you want the results sorted in a particular order.

sidsel

I know. In the examle query I would like the order to be 1000,5000,3000

HalfaBee

what sort of order is that?
Is there some logic behind the order?

I think you will have to just select all the rows and use a script to extract the values in the order you want.

sidsel

The query should return a list of "last viewed items".

An array stored in a session contains the last 3 viewed itemid's ie. (1000, 5000, 3000)

The last viewed item should be in top (in example itemid 1000).

The query probably needs to be formatted in different way.

NogDog

There's probably a simpler way if we knew the entire logic behind this, but with the information and table column info at hand, all I can think of is:

SELECT desc, FIELD(itemid, 1000, 5000, 3000) AS sort_order
FROM table WHERE itemid = 1000 OR itemid = 5000 OR itemid = 3000
ORDER BY sort_order