欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  后端开发

数据库 - php先按year倒序查询 再按term为2的先查询 为1的后查询

程序员文章站 2022-06-10 18:45:27
...
Array
(
    [id] => 1
    [user_id] => 1
    [year] => 2013-2014
    [term] => 1

)
Array
(
    [id] => 2
    [user_id] => 1
    [year] => 2013-2014
    [term] => 2

)
Array
(
    [id] => 3
    [user_id] => 1
    [year] => 2012-2013
    [term] => 1

)

如上面 先在year倒序查询的情况下 再按term为2的先查询 为1的后查询 最好用thinkphp
应该查出来是这样的

Array
(
    [id] => 2
    [user_id] => 1
    [year] => 2013-2014
    [term] => 2

)
Array
(
    [id] => 1
    [user_id] => 1
    [year] => 2013-2014
    [term] => 1

)
Array
(
    [id] => 3
    [user_id] => 1
    [year] => 2012-2013
    [term] => 1

)

回复内容:

Array
(
    [id] => 1
    [user_id] => 1
    [year] => 2013-2014
    [term] => 1

)
Array
(
    [id] => 2
    [user_id] => 1
    [year] => 2013-2014
    [term] => 2

)
Array
(
    [id] => 3
    [user_id] => 1
    [year] => 2012-2013
    [term] => 1

)

如上面 先在year倒序查询的情况下 再按term为2的先查询 为1的后查询 最好用thinkphp
应该查出来是这样的

Array
(
    [id] => 2
    [user_id] => 1
    [year] => 2013-2014
    [term] => 2

)
Array
(
    [id] => 1
    [user_id] => 1
    [year] => 2013-2014
    [term] => 1

)
Array
(
    [id] => 3
    [user_id] => 1
    [year] => 2012-2013
    [term] => 1

)

ORDER关键字是可以给多个字段的

ORDER BY `year` DESC, `term` DESC