查询语言.groupBy

函数原型

  1. public function order($mixExpr);

说明：参数支持字符串以及它们构成的一维数组，用法和 orderBy 非常相似。

用法如下

  1. # SELECT `test`.`tid` AS `id`,`test`.`tname` AS `value`  FROM `test`  GROUP BY `test`.`id`,`test`.`name`
  2. Db::table('test', 'tid as id,tname as value')->
  4. groupBy('id')->
  6. groupBy('name')->
  8. getAll();
  10. # SELECT `test`.`tid` AS `id`,`test`.`tname` AS `value`  FROM `test`  GROUP BY `post`.`id`
  11. Db::table('test', 'tid as id,tname as value')->
  13. groupBy('post.id')->
  15. getAll();
  17. # SELECT `test`.`tid` AS `id`,`test`.`tname` AS `value`  FROM `test`  GROUP BY SUM(`test`.`num`) 
  18. Db::table('test', 'tid as id,tname as value')->
  20. groupBy('{SUM([num])}')->
  22. getAll();
  24. # SELECT `test`.`tid` AS `id`,`test`.`tname` AS `value`  FROM `test`  GROUP BY `test`.`title`,`test`.`id`,concat('1234',`test`.`id`,'ttt')
  25. Db::table('test', 'tid as id,tname as value')->
  27. groupBy("title,id,{concat('1234',[id],'ttt')}")->
  29. getAll();
  31. # SELECT `test`.`tid` AS `id`,`test`.`tname` AS `value`  FROM `test`  GROUP BY `test`.`title`,`test`.`id`,`test`.`ttt`,`test`.`value`
  32. Db::table('test', 'tid as id,tname as value')->
  34. groupBy(['title,id,ttt', 'value'])->
  36. getAll();