Skip to main content
Quick Tip

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 ▼
}
]
*/
 
$users = User::select('email as user_email')->get();
 
/* RESULT:
array:1 [▶
0 => App\Models\User {#3204 ▼
user_email: "[email protected]"
}
]
*/

Enjoyed This Tip?

Get access to all premium tutorials, video and text courses, and exclusive Laravel resources. Join our community of 10,000+ developers.

We'd Love Your Feedback

Tell us what you like or what we can improve

Feel free to share anything you like or dislike about this page or the platform in general.