How to return a column with different name in Laravel

• 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