Column name change

In Eloquent or Query Builder method select(), you can specify "as" to return any column with a different name, just like in plain SQL query.

$users = User::select('email')->get();
 
/* RESULT:
array:1 [▶
0 => App\Models\User {#3204 ▼
email: "geovanni.schulist@example.org"
}
]
*/
 
$users = User::select('email as user_email')->get();
 
/* RESULT:
array:1 [▶
0 => App\Models\User {#3204 ▼
user_email: "geovanni.schulist@example.org"
}
]
*/

Like our articles?

Become a Premium Member for $129/year or $29/month
What else you will get:
  • 59 courses (1057 lessons, total 42 h 44 min)
  • 79 long-form tutorials (one new every week)
  • access to project repositories
  • access to private Discord

Recent Premium Tutorials