如何在Laravel中使用GROUP_CONCAT [英] how to use GROUP_CONCAT in laravel

问题描述

$assignment = assignment::find(Crypt::decrypt($id));
$assignment_details = $assignment->raw_plan()->groupBy('flag')->get();

我想在laravel中跟踪此查询的结果

I want to following result of this query in laravel

SELECT GROUP_CONCAT(name) AS 'names' FROM `raw_plans` where `assignment_id` = 1 GROUP BY`flag`

请建议我如何在Laravel中使用GROUP_CONCAT

Please suggest me how to use GROUP_CONCAT in laravel

推荐答案

您可以将关系用作查询生成器，以如下方式获取结果:

You can use relations as query builder to fetch the results as:

$assignment_details = $assignment->raw_plan()
                                ->select(DB::raw('group_concat(name) as names'))
                                ->where('assignment_id', 1)
                                ->groupBy('flag')
                                ->get();

更新

使用table_name.*进行选择以获取所有字段.

Use table_name.* in select to get all the fields.

$assignment_details = $assignment->raw_plan()
                                ->select('raw_plans.*', DB::raw('group_concat(name) as names'))
                                ->where('assignment_id', 1)
                                ->groupBy('flag')
                                ->get();

这篇关于如何在Laravel中使用GROUP_CONCAT的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！