How to alias a table in Laravel Eloquent queries (or using Query Builder)?

by

Laravel supports aliases on tables and columns with AS. Try

$users = DB::table('really_long_table_name AS t')
           ->select('t.id AS uid')
           ->get();

Let’s see it in action with an awesome tinker tool

$ php artisan tinker
[1] > Schema::create('really_long_table_name', function($table) {$table->increments('id');});
// NULL
[2] > DB::table('really_long_table_name')->insert(['id' => null]);
// true
[3] > DB::table('really_long_table_name AS t')->select('t.id AS uid')->get();
// array(
//   0 => object(stdClass)(
//     'uid' => '1'
//   )
// )

More Related Contents:

  1. Laravel Check If Related Model Exists
  2. Laravel Eloquent: How to order results of related models?
  3. Laravel 4: how to “order by” using Eloquent ORM [duplicate]
  4. How to set a default attribute value for a Laravel / Eloquent model?
  5. Laravel Eloquent – Attach vs Sync
  6. How to create a subquery using Laravel Eloquent?
  7. Update without touching timestamps (Laravel)
  8. Eloquent model mass update
  9. How can I query raw via Eloquent?
  10. Find or Create with Eloquent
  11. Laravel Many to many self referencing table only works one way
  12. Laravel one to many relation with a one to one relation
  13. Bulk Insertion in Laravel using eloquent ORM
  14. Laravel blank white screen
  15. Laravel, sync() – how to sync an array and also pass additional pivot fields?
  16. Laravel 5.2 – Use a String as a Custom Primary Key for Eloquent Table becomes 0
  17. Composer killed while updating
  18. Laravel $q->where() between dates
  19. belongsToMany relationship in Laravel across multiple databases
  20. How Can I Set the Default Value of a Timestamp Column to the Current Timestamp with Laravel Migrations?
  21. file_put_contents(meta/services.json): failed to open stream: Permission denied
  22. How to Make Laravel Eloquent “IN” Query?
  23. Laravel merge relationships
  24. PHP Composer update “cannot allocate memory” error (using Laravel 4)
  25. Laravel Eloquent sort by relation table column
  26. How can I install mcrypt under PHP7? Laravel needs it
  27. Eloquent Parent-Child relationship on same model
  28. Unresolvable dependency resolving [Parameter #0 [ $name ]]
  29. Laravel Form methods VS traditional coding
  30. Symfony\Component\HttpKernel\Exception\NotFoundHttpException Laravel

Leave a Comment