/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

14 votes327 views6 answers
Update query in laravel eloquent
PHP Laravel
0 vote356 views1 answer
Datetime-local laravel migration data type
PHP Laravel
5 votes338 views3 answers
Drop column table in migration if exist in laravel
PHP Laravel
6 votes321 views2 answers
Laravel migration table column nullable
PHP Laravel
1 vote347 views1 answer
Groupby in laravel with count
PHP Laravel
11 votes326 views3 answers
Blade condition if else laravel
PHP Laravel
49 votes441 views6 answers
Join in laravel
PHP Laravel
1 vote469 views1 answer
Laravel profile migration tool
PHP Laravel
0 vote360 views1 answer
Laravel subtract date
PHP Laravel
5 votes336 views3 answers
Crrate model in laravel
PHP Laravel