/PHP/Laravel/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 votes121 views4 answers
Session has laravel blade
PHP Laravel
0 vote114 views1 answer
Laravel npm build production
PHP Laravel
0 vote128 views1 answer
Laravel weekly data
PHP Laravel
0 vote122 views1 answer
Laravel delete controller still cached
PHP Laravel
5 votes124 views4 answers
Laravel model wherein
PHP Laravel
0 vote151 views1 answer
Edit items in Laravel collection
PHP Laravel
1 vote135 views1 answer
Bootstrap doesn't work in laravel
PHP Laravel
1 vote124 views1 answer
Get specific columns using with() function in laravel eloquent
PHP Laravel
0 vote136 views1 answer
Laravel validate number to be at least 3 digits
PHP Laravel
1 vote138 views1 answer
Stack once laravel
PHP Laravel