How to get specific column with custom column name on Laravel

Question

Looking for a way to get specific columns from Laravel Eloquent with custom column names.

E.g. get example_name as name.

I am trying to replicate SQL Alias like SELECT column_name AS alias_name but without using custom attributes.

Here is and example query in Laravel:

Table::get(['column1', 'column2', 'column3'])->all()

And what I would like it to get would look something like this:

Table::get(['column1', 'column2 AS column4', 'column3'])->all()

Jignesh Joisar · Accepted Answer · 2019-06-14 12:59:52Z

2

for example in user model email as emailAddress u want to get then in your user model do like that

protected $appends = ['emailAddress']; //add custom column here..

public function getEmailAddressAttribute()
{
     return $this->email;
}

or u can use by query like that

User::select('id','name','email as emailAddress')->get();

Table::select('column1', 'column2 AS column4', 'column3')->get()

answered Jun 14, 2019 at 12:53

Jignesh Joisar

15.4k6 gold badges69 silver badges61 bronze badges

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

2 Comments

I was using 'get' instead of 'select', therefore it was not working for me. Thanks a lot!

@butaminas no worry