/PHP/How to alias table name in laravel model

How to alias table name in laravel model

Item
    ::from( 'items as items_alias' )
    ->join( 'attachments as att', DB::raw( 'att.item_id' ), '=', DB::raw( 'items_alias.id' ) )
    ->select( DB::raw( 'items_alias.*' ) )
    ->get();

Source: stackoverflow.com

Similar codes

6 votes152 views2 answers
Laravel 6 get user id
PHP Laravel
0 vote173 views1 answer
How to calculate age using query builder in laravel?
PHP Laravel
2 votes133 views1 answer
Laravel artisan create criteria
PHP Laravel
0 vote136 views3 answers
Laravel pagination with search filter
PHP Laravel
8 votes140 views3 answers
Force delete soft delete laravel
PHP Laravel
0 vote152 views2 answers
How to concat in where clause like laravel query builder
PHP Laravel
12 votes121 views2 answers
Tomorrow carbon laravel
PHP
4 votes136 views2 answers
How validate hash string in laravel
PHP
1 vote117 views2 answers
Download file in php
PHP
3 votes124 views2 answers
Default port for laravel
PHP