Php + Mysql，按id +命令以特定id开头

Question

ID | NAME
1  | yassine
2  | yask
3  | oisus
4  | iouosiud
5  | iouous

$query = mysql_query("SELECT * FROM table ORDER BY id DESC");

what i want to do is that i want to start with 3 . It should output like this:

3,1,2,4,5.

is it possible ?

Answer 1

This works:

SELECT * FROM table ORDER BY id=3 DESC, id ASC

Arranged the list using ORDER BY.