AI写作智能体 自主规划任务,支持联网查询和网页读取,多模态高效创作各类分析报告、商业计划、营销方案、教学内容等。 广告
# 函数原型 ~~~ public function order($mixExpr); ~~~ 说明:参数支持字符串以及它们构成的一维数组,用法和 orderBy 非常相似。 # 用法如下 ~~~ # SELECT `test`.`tid` AS `id`,`test`.`tname` AS `value` FROM `test` GROUP BY `test`.`id`,`test`.`name` database::table ( 'test', 'tid as id,tname as value' ) ->groupBy('id') ->groupBy('name') ->getAll (); # SELECT `test`.`tid` AS `id`,`test`.`tname` AS `value` FROM `test` GROUP BY `post`.`id` database::table ( 'test', 'tid as id,tname as value' ) ->groupBy('post.id') ->getAll (); # SELECT `test`.`tid` AS `id`,`test`.`tname` AS `value` FROM `test` GROUP BY SUM(`test`.`num`) database::table ( 'test', 'tid as id,tname as value' ) ->groupBy('{SUM([num])}') ->getAll (); # SELECT `test`.`tid` AS `id`,`test`.`tname` AS `value` FROM `test` GROUP BY `test`.`title`,`test`.`id`,concat('1234','`test`.`id`','ttt') database::table ( 'test', 'tid as id,tname as value' ) ->groupBy("title,id,{concat('1234','[id]','ttt')}") ->getAll (); # SELECT `test`.`tid` AS `id`,`test`.`tname` AS `value` FROM `test` GROUP BY `test`.`title`,`test`.`id`,`test`.`ttt`,`test`.`value` database::table ( 'test', 'tid as id,tname as value' ) ->groupBy(['title,id,ttt','value']) ->getAll (); ~~~