Add custom field during select mysql in laravel query

Question

I have this query in laravel 5.2

$obj_custom_stdy_data = QstCustomStudyData::where('student_id', $this->data_user['student_id'])
                    ->select($list_id . ' as list_id ', 'chapter_id', 'subject_id', 'subject_code_id')
                    ->get()
                    ->toArray();

Well I have a fixed value $list_id got from top code. Actually I want to add new field during query selection as list_id. However I got error for such that method.

When I tried in mysql IDE for example:

SELECT (1+2) as total, c.* FROM users

Then the result is no wrong at all.

Is that anyway to write in query builder for laravel instead of raw style?

Saumya Rastogi · Accepted Answer · 2016-12-06 14:26:57Z

2

You can take the use of DB::raw() method of QueryBuilder like this:

->select(DB::raw('(1+2) as total'));

See more about Query Builder's Raw Expressions

Hope this helps!

answered Dec 6, 2016 at 14:26

Saumya Rastogi

13.8k5 gold badges45 silver badges45 bronze badges

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

2 Comments

Nere Over a year ago

Thanks! Very fast response.

Saumya Rastogi Over a year ago

Thanks, Glad to see that it helps you to resolve your problem!

Collectives™ on Stack Overflow

Add custom field during select mysql in laravel query

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related