Laravel Query Builder - Complex select column error

Question

I have 2 table like this-

panelists

users

I have a Laravel 5.1 query builder like this-

    $baseQuery = DB::table('panelists')
        ->join('users', 'panelists.user_id', '=', 'users.id')
        ->select(
            'users.id',
            'users.name',
            'users.email',
            'IF(enabled=1,"English Book","Other Language")   AS status'
        )
        ->where('panelists.customer_id', '=', $user_ID);

But it is giving me error for

          'IF(enabled=1,"English Book","Other Language")   AS status'

Can anyone help please?

Post exact error message

Charlotte Dunois
– Charlotte Dunois

2015-09-26 23:59:38 +00:00
Commented Sep 26, 2015 at 23:59 — Charlotte Dunois
– Charlotte Dunois, Commented Sep 26, 2015 at 23:59
Try DB::raw for raw queries.

aldrin27
– aldrin27

2015-09-27 00:45:31 +00:00
Commented Sep 27, 2015 at 0:45 — aldrin27
– aldrin27, Commented Sep 27, 2015 at 0:45

aldrin27 · Accepted Answer · 2015-09-27 00:41:18Z

1

Try this: You may use DB::Raw for raw queries.

$baseQuery = DB::table('panelists')
    ->join('users', 'panelists.user_id', '=', 'users.id')
    ->select(
        'users.id',
        'users.name',
        'users.email',
         DB::raw('IF(enabled=1,"English Book","Other Language")AS status')
    )
    ->where('panelists.customer_id', '=', $user_ID);

answered Sep 27, 2015 at 0:41

aldrin27

3,4184 gold badges31 silver badges44 bronze badges

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

Collectives™ on Stack Overflow

Laravel Query Builder - Complex select column error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related