mysql SQL: specific item to be first and then to sort the rest of the items

Question

Lets say I have the table below.

I want to get all the friends, but I want the id 5 to be the first item in the list. I don't care about the order that I receive the rest of the items.

The desired query result will be:

friends -------  id    name  5     nahum 1     moshe 2     haim 3     yusuf 4     gedalia 6     dana 

How can I do this?

using Mysql 5.1.x.

Thanks!

Answer 1

select id,name  from friends  order by id=5 desc 

(given you don't care about order of the rest, otherwise, e.g. rest by id asc)

select id,name  from friends  order by id=5 desc, id asc 

Answer 2

Try this:

select id,name  from friends  order by case when id=5 then -1 else id end 

if you have more then one you can do:

select id,name  from friends  order by case when id in (5,15,25) then -1 else id end,id