[SOLVED] Order by statement

[mishuk]

Is it possible to order the results of an sql statement by specifying which value you want at the top of the list and the rest can be in any order.

 

For example if i had a table that had the values 1 - 10 in them and i wanted to select each value but wanted the value 5 at the top followed by the rest.

 

e.g

5

1

2

3

4

6

7

and so on

 

Is this possible in any way?

[bubblegum.anarchy]

This query seems to work:

SELECT * FROM table_name ORDER BY id = 5 desc, id

[mishuk]

just what i wanted.  Cheers