php + mysql，按名称+以特定ID开头 [英] php + mysql, order by name + starting at specific id

问题描述

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 开始，所以它应该输出:

what I want to do though is, I want to start at id: 3, so it should output:

3,4,5,1,2

3,4,5,1,2

推荐答案

标记正确.先前的查询在语法上不正确. 使用虚拟别名应该有效！

EDIT : Mark is correct. The earlier query was syntactically incorrect. Using dummy aliasés should work!

Select id from
(
    SELECT id FROM table_name 
    WHERE id >= 3 
    ORDER BY id ASC
) X   

UNION

Select * from
(
    SELECT id FROM table_name 
    WHERE id < 3 
    ORDER BY id ASC
) Y

这应该给您3,4,5,1,2

This should give you 3,4,5,1,2

这篇关于php + mysql，按名称+以特定ID开头的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！