Php + Mysql，按id +命令以特定id开头
问题描述：
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 ?
ID | NAME
1 | yassine
2 | yask
3 | oisus
4 | iouosiud
5 | iouous
code> pre>
$ query = mysql_query（“SELECT * FROM table ORDER BY id DESC”）; p>
blockquote>
我想要做的是我想从3开始。 它应该输出如下： p>
3,1,2,4,5。 p>
是否可能？ p>
DIV>
答
This works:
SELECT * FROM table ORDER BY id=3 DESC, id ASC
Arranged the list using ORDER BY.
答
SELECT * FROM `table` ORDER BY (id=3) ASC
No need to use union!