Search by Queries/Bugs/Errors

How to return a column with different name in Laravel

Sometimes you have to get the column of the table with a different name. In that case you can use as in the select to get the column with a different column name.

Return a column with different name in Laravel using Eloquent Query Builder

$users = DB::table('users')->select('name', 'email as user_email')->get();
dd($users);

Output:

^ Illuminate\Support\Collection {#1437 ▼
  #items: array:15 [▼
    0 => {#1438 ▼
      +"name": "summer"
      +"user_email": "[email protected]"
    }
    1 => {#1441 ▶}
    2 => {#1442 ▶}
    3 => {#1443 ▶}
    4 => {#1444 ▶}
    5 => {#1445 ▶}
    6 => {#1446 ▶}
    7 => {#1447 ▶}
    8 => {#1448 ▶}
    9 => {#1449 ▶}
    10 => {#1450 ▶}
    11 => {#1451 ▶}
    12 => {#1452 ▶}
    13 => {#1453 ▶}
    14 => {#1454 ▶}
  ]
}

It will return the records from the users table with column email as user_email. Output may varies. In may case i have 15 records in my users table which return name and email as user_email after using this code snippet.

Back to code snippet queries related laravel

Bootstrap Cmd CodeIgniter Css Drupal Git Html Javascript Jquery Laravel Nodejs Php Python Sql Typescript Wordpress

How to return a column with different name in Laravel

Return a column with different name in Laravel using Eloquent Query Builder

Random Code Snippet Queries: Laravel

Share on social media