查询语言.orderBy

函数原型

public function order($mixExpr);

说明:参数支持字符串以及它们构成的一维数组。

用法如下

# SELECT `test`.`tid` AS `id`,`test`.`tname` AS `value`  FROM `test`  ORDER BY `test`.`id` DESC,`test`.`name` ASC
Db::table('test', 'tid as id,tname as value')->

orderBy('id DESC')->

orderBy('name')->

getAll();
    
# SELECT `test`.`tid` AS `id`,`test`.`tname` AS `value`  FROM `test`  ORDER BY `test`.`id` DESC
Db::table('test', 'tid as id,tname as value')->

orderBy('test.id DESC')->

getAll();

# SELECT `test`.`tid` AS `id`,`test`.`tname` AS `value`  FROM `test`  ORDER BY SUM(`test`.`num`) ASC
Db::table('test', 'tid as id,tname as value')->

orderBy('{SUM([num]) ASC}')->

getAll();
   
# SELECT `test`.`tid` AS `id`,`test`.`tname` AS `value`  FROM `test`  ORDER BY `test`.`title` ASC,`test`.`id` ASC,concat('1234',`test`.`id`,'ttt') DESC
Db::table('test', 'tid as id,tname as value')->

orderBy("title,id,{concat('1234',[id],'ttt') desc}")->

getAll();
    
# SELECT `test`.`tid` AS `id`,`test`.`tname` AS `value`  FROM `test`  ORDER BY `test`.`title` ASC,`test`.`id` ASC,`test`.`ttt` ASC,`test`.`value` DESC
Db::table('test', 'tid as id,tname as value')->

orderBy(['title,id,ttt', 'value desc'])->

getAll();

# SELECT `test`.`tid` AS `id`,`test`.`tname` AS `value`  FROM `test`  ORDER BY `test`.`title` DESC,`test`.`id` DESC,`test`.`ttt` ASC,`test`.`value` DESC
Db::table('test', 'tid as id,tname as value')->

orderBy(['title,id,ttt asc', 'value'], 'desc')->

getAll();

快捷排序 latest/oldest

# SELECT `test`.* FROM `test` ORDER BY `test`.`create_at` DESC
Db::->table('test')->

latest()->

getAll();

# SELECT `test`.* FROM `test` ORDER BY `test`.`foo` DESC
Db::->table('test')->

latest('foo')->

getAll();

# SELECT `test`.* FROM `test` ORDER BY `test`.`create_at` ASC
Db::->table('test')->

oldest()->

getAll();

# SELECT `test`.* FROM `test` ORDER BY `test`.`bar` ASC
Db::->table('test')->

oldest('bar')->

getAll();
上次更新: 2018/11/14 上午9:23:00