• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Tutsplanet

Tutsplanet

Free Technical and Blogging Resources

  • Home
  • Web Hosting
  • Programming
  • Plugins
  • Twitter Trends
  • Tools
  • About Us

Programming TagsLaravel

Laravel Eloquent Select Column as Alias

May 30, 2022 Editorial Staff Leave a Comment

Share
Tweet
Share

Did you ever think about using an alias in the select columns while using Laravel Eloquent?. We cannot say it’s very Laravel specific, rather a MySql feature. Basically, when you join two or more tables in MySql, chances are very high that you will have the same column names multiple times in the result. This will throw an ambiguous column error in MySql.

So as a solution we will use as keyword in the MySql to create aliases for the columns.

This is very true for Laravel’s eloquent as well. You can use the Select column alias in Laravel Eloquent.

For example, you have two tables users and groups, and both have common fields like the name. So how is your query will look like

User::select('users.name as user_name','groups.name as group_name as group_name)
            ->join('groups', 'users.group_id', '=', 'groups.id')

Related Posts

  • What is the opposite of has() method in Laravel?
  • Laravel: Download files to storage from SFTP
  • Laravel Eloquent- Where Condition with Two Columns
  • How to Add Foreign Key in Laravel Migration?
  • What is Str::finish() in Laravel ?
  • How to Substract and Add Hours in Laravel Using Carbon?
  • How to Get Last Week Data in Laravel using Carbon?
  • Differences between query() and input() in Laravel?
  • Raw Queries in Laravel
  • Laravel 8 Eloquent updateOrCreate() Example
  • What does Model::unguard() do in Laravel?
  • collect.js – A Laravel collection clone in JavaScript
  • How to Export CSV file in Laravel Example
  • How to create Your Own Custom Log File in Laravel
  • Laravel db raw and whereRaw() where clause example
  • Laravel Artisan command for generating Request validation Class
  • Bind vs Singleton in Laravel. Which one to use, and when?
  • Attribute Casting with Laravel
  • How To Get HTTP Hostname In Laravel ?
  • How to call static function from Helper in Laravel blade file?
  • Laravel WhereHas() Eloquent Example
  • How to Rollback migration in Laravel ?
  • Laravel str is() Function With Example
  • How to use Faker with Laravel ?
  • How to Add Foreign Key in Laravel Migration?
  • Check for the application environment in Laravel views or controller
  • How to Get a List of Registered Route Paths in Laravel 8?
  • Two ways to set default DB column value in Laravel
  • How to constrain a route parameter with a given regular expression globally in Laravel?
  • Add default current timestamp to Laravel migration
  • Using Laravel’s dd (dump and die) function in your application
  • Laravel 8 – Ajax File Upload with Progress Bar
  • Laravel 8 Create Custom Helper Functions (Global function)
  • Automatically Set a Local Timezone for Users In Laravel
  • Force HTTPS with a Middleware in Laravel
  • Difference between Laravel’s raw SQL functions
  • Laravel date set timezone
  • How to create console command in laravel ?
  • How to clear laravel.log in Laravel?
  • How to create a custom console command (artisan) for Laravel
  • Hierarchical Tree view Category Example in Laravel
  • How To Install And Use CKEditor In Laravel?
  • Laravel Auth: Login with username instead of Email
  • What is Laravel Mass Assignment, Guarded or Fillable?
  • Laravel Image Intervention Tutorial With Example
  • How to delete file from public folder in Laravel?
  • How to run Laravel validation if the field is not empty?
  • How to select specific columns in laravel eloquent ORM?
  • How to Use reCAPTCHA in Laravel 5 Forms For Validation
  • Redirect urls to HTTPS in Laravel 5

Editorial Staff

Editorial Staff at Tutsplanet is a dedicated team to write various tutorials about subjects like Programming, Technology and Operating Systems.

View all posts by Editorial Staff

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Quick Links

  • Top 21 Website Ideas To Make Money Online in 2021
  • A Simple YouTube Video Downloader Script in PHP
  • The 50 Most Useful jQuery Plugins for Frontend Development
  • Replace “\n” with new line characters, using Notepad++
  • Using Third-Party Libraries in Codeigniter
  • Upload Multiple Images and Store in Database using PHP and MySQL.
  • Hierarchical Tree view Category Example in Laravel
  • Laravel Image Intervention Tutorial With Example
  • How to import sql file in MySQL database using PHP?
  • Free VAT Calculator Online

Subscribe

* indicates required



Search Here

Share

   



Hot topics

  • Replace “\n” with new line characters, using Notepad++ 37 views
  • How to enter new line in Microsoft Teams? 34 views
  • Simple PHP Shopping Cart 18 views
  • Add FTP/SFTP in Visual Studio Code 15 views
  • Open a URL in a new tab using JavaScript 13 views
  • Laravel: Download files to storage from SFTP 12 views
  • Solution: windows photo viewer opens each time save a pic file 12 views
  • A Simple YouTube Video Downloader Script in PHP 11 views
  • Laravel Eloquent Select Column as Alias 11 views
  • Get Uploads Directory Path in WordPress 9 views

Categories

  • Design & Development
  • Drupal
  • Facebook
  • General
  • How To
  • ios
  • Javascript
  • Linux
  • Magento
  • Marketing
  • News
  • PHP
  • Plugins
  • Programming
  • Snippets List
  • Social Media
  • Softwares
  • Themes
  • Tips
  • Wordpress
  • YouTube























Copyright © 2023 · Planet on Genesis Framework · Powered By BunnyCDN . Network wallpapernoon.com