/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

28 votes283 views12 answers
Laravel middleware
PHP Laravel
0 vote336 views1 answer
Laravel get data from model to controller
PHP Laravel
1 vote355 views2 answers
Insert batch in laravel
PHP Laravel
1 vote364 views1 answer
Human readable date laravel
PHP Laravel
0 vote311 views2 answers
Laravel project make
PHP Laravel
0 vote518 views1 answer
Download laravel 8 zip
PHP Laravel
1 vote386 views2 answers
Pass image path in laravel blade
PHP Laravel
1 vote383 views1 answer
Publish config laravel
PHP Laravel
13 votes347 views6 answers
Laravel manually authenticate user
PHP Laravel
0 vote352 views1 answer
How to select specific id in laravel using isset
PHP Laravel