How to convert mysql to query builder in laravel

Question

I have this raw query in MySQL I need to translate to laravel 5.5 query builder. Thanks

SELECT
group_table.id,
group_table.name,
group_table.description,
GROUP_CONCAT(
    group_table.languageName SEPARATOR ', '
) as languages
FROM
(
    SELECT
        translate_groups.id,
        translate_groups.name,
        translate_groups.description,
        languages.name as languageName
    FROM
        translate_groups
    LEFT JOIN language_translate_group ON
        language_translate_group.translate_group_id = translate_groups.id
    LEFT JOIN languages ON
        language_translate_group.language_id = languages.id
) group_table
GROUP BY
group_table.id,
group_table.name,
group_table.description

Please fix the formatting of your query so that we may read it. — Tim Biegeleisen
– Tim Biegeleisen, Commented May 29, 2018 at 7:41
Possible duplicate of How to create a subquery using Laravel Eloquent? — online Thomas
– online Thomas, Commented May 29, 2018 at 8:01

Amin.Qarabaqi · Accepted Answer · 2018-05-29 15:27:14Z

0

you can run any raw query you want in query builder:

$queryString = 'WHAT RAW QUERY YOU WANT';
$result = DB::select(DB::raw($queryString));

just make use of Illuminate\Support\Facades\DB;

answered May 29, 2018 at 15:27

Amin.Qarabaqi

7231 gold badge7 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Thoan Pham Over a year ago

I need to translate to laravel 5.5 query builder. ( not collection)

Collectives™ on Stack Overflow

How to convert mysql to query builder in laravel

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related