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.

Recent Courses on Laravel Daily