Posts Learn Components Snippets Categories Tags Tools About
/

How to Alias Column Name in Laravel Select

Learn how to alias the column name of a table inside the eloquent select statement

Created on Aug 06, 2021

2398 views

When querying an eloquent model, you can alias / change the name of the selected column before returning it to the front-end. To do so you can make use of the "as" keyword within the "select" method.
$user = User::select(['id', 'name as nickname'])->first();

The query above will get the first user and the only column that will be retrieved is the "nickname".

If you are joining a table then make sure to use the "." dot syntax to specify which of the table column you are referring to.
Post::join('comments', 'posts.id', '=', 'comments.id')
    ->select('comments.title as subject')
    ->get();

If you like our tutorial, do make sure to support us by being our Patreon or buy us some coffee ☕️

Load comments for How to Alias Column Name in Laravel Select

new

PostSrc Code Components

Collection of Tailwind CSS components for everyone to use. Browse all of the components that are right for your project.

View Components

Sponsors 👑

+ Add Yours
)