/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

50 votes486 views6 answers
Add column in laravel migration
PHP Laravel
0 vote185 views1 answer
Laravel scheduler on shared hosting
PHP Laravel
0 vote199 views1 answer
Comment php laravel template blade
PHP Laravel
2 votes171 views1 answer
Laravel model wherein update
PHP Laravel
11 votes176 views3 answers
Laravel auth 6
PHP Laravel
0 vote181 views1 answer
Server error in laravel
PHP Laravel
1 vote215 views2 answers
Laravel collection implode
PHP Laravel
0 vote180 views1 answer
Only get selected value from has many ralation laravel
PHP Laravel
11 votes203 views3 answers
Blade condition if else laravel
PHP Laravel
11 votes193 views2 answers
Laravel mass update relationship
PHP Laravel