Laravel query builder select name

Question

In the following:

DB::table('users')
    ->join('item', 'users.id', '=', 'item.user_id')
    ->select('item.name')
    ->get();

Is there a way to reference 'item.name' as just 'name'?

lukasgeiter · Accepted Answer · 2015-01-11 08:06:39Z

3

Sure. You need to use either DB::raw or selectRaw

select(DB::raw('item.name AS name'))

Or

selectRaw('item.name AS name')

answered Jan 11, 2015 at 8:06

lukasgeiter

154k29 gold badges349 silver badges280 bronze badges

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

2 Comments

If there's more than one would it look like this? selectRaw('item.name AS name', 'item.name2 AS name2')?

No. You need to pass them as string selectRaw('item.name AS name, item.name2 AS name2')