• 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 getOrPut in Laravel?
  • 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
Did this post help you?
Tutsplanet brings in-depth and easy tutorials to understand even for beginners. This takes a considerable amount of work. If this post helps you, please consider supporting us as a token of appreciation:
  • Just want to thank us? Buy us a Coffee
  • May be another day? Shop on Amazon using our links.
    Your prices won't change but we get a small commission.

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++ 29 views
  • A Simple YouTube Video Downloader Script in PHP 21 views
  • Add FTP/SFTP in Visual Studio Code 18 views
  • Open a URL in a new tab using JavaScript 17 views
  • PHP: Implode () with quotes 16 views
  • How to enter new line in Microsoft Teams? 13 views
  • Hierarchical Tree view Category Example in Laravel 12 views
  • All Countries SQL file with Country Codes to Download 12 views
  • Post Data to an iframe 10 views
  • Auto Login in PuTTY with a password 10 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