Laravel Query for MySQL Concat

Question

I have a table like this-

webinars

I want to have a query in Laravel Query Builder like this-

    // Base Query
    $baseQuery = DB::table('webinars')
        //->join('users', 'panelists.user_id', '=', 'users.id')
        ->select(
            'id',
            'title',
            'description',
            'hosts',
            DB::raw('concat(starts_on, ' ', timezone) as starts'),
            'duration',
            'created_at'
        )
        ->where('user_id', '=', $user_ID);

And getting error for-

     DB::raw('concat(starts_on, ' ', timezone) as starts')

I need it because I want something like =>

today JPN

if starts_on=today and timezone='JPN'

Can anyone pleae help?

marc_s · Accepted Answer · 2015-10-24 08:17:44Z

4

DB::raw('concat(starts_on, ' ', timezone) as starts')

:- You have added single quote inside single quote.

You can try this:

// Base Query
$baseQuery = DB::table('webinars')
    //->join('users', 'panelists.user_id', '=', 'users.id')
    ->select(
        'id',
        'title',
        'description',
        'hosts',
        DB::raw('concat(starts_on, " ", timezone) as starts'),
        'duration',
        'created_at'
    )
    ->where('user_id', '=', $user_ID);

edited Oct 24, 2015 at 8:17

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Sep 27, 2015 at 7:34

Abhishekh Gupta

6,2464 gold badges20 silver badges49 bronze badges

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

Collectives™ on Stack Overflow

Laravel Query for MySQL Concat

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