这是我一直在寻找的答案。我希望我不会为此而感到沮丧,但是我设法解决了这个问题。
让我再次解释一些更简单的术语。MysqL ORDER BY +开始于..
MysqL:
id | name |
------------
1 | Joe |
2 | Craig |
3 | Shawn |
4 | Ryan |
5 | Seth |
PHP:
$a = MysqL_query("SELECT * FROM table_name ORDER BY name DESC");
我想做的是,我想从id:3开始,所以它应该输出:
3,4,5,1,2
SELECT id, name
FROM table_name
ORDER BY id < 3, id
结果:
3 Shawn
4 Ryan
5 Seth
1 Joe
2 Craig
您可以使用FIELD
,例如
SELECT *
FROM products
ORDER BY FIELD(`order`, 6) ASC