With a SELECT...WHERE id IN (...), order results by IN() ?

Question

Possible Duplicate:
Ordering by the order of values in a SQL IN() clause

With a query such as:

SELECT * FROM images WHERE id IN (12,9,15,3,1)

is it possible to order the results by the contents of the IN clause?

The result I'm looking for would be something like:

[0] => Array
    (
        [id] => 12
        [file_name] => foo
    )   
[1] => Array
    (
        [id] => 9
        [file_name] => bar
    )   
[2] => Array
    (
        [id] => 15
        [file_name] => baz
    )
...

Answer 1

The IN clause defines a set, and a set in mathematics has no order.

However there seems to be a workaround for MySQL by using the FIELD() function:

• Ordering by the order of values in a SQL IN() clause

Answer 2

select * from images
where id in (12,9,15,3,1)
order by
    case
        id when 12 then 1
        when 9 then 2
        when 15 then 3
        when 3 then 4
        when 1 then 5
    end