/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

0 vote150 views7 answers
Laravel eloquent tricks
PHP Laravel
2 votes112 views2 answers
Get relationship data from soft delete laravel
PHP Laravel
0 vote114 views2 answers
Adminlte con laravel 8
PHP Laravel
3 votes113 views1 answer
How validate array in laravel in request
PHP Laravel
2 votes108 views4 answers
Laravel htaccess
PHP Laravel
2 votes128 views1 answer
Laravel get subdomain
PHP Laravel
1 vote123 views2 answers
Page expire in laravel
PHP Laravel
1 vote117 views1 answer
Publishing laravel module package
PHP Laravel
1 vote118 views6 answers
Laravel get url parameters in controller
PHP Laravel
1 vote109 views1 answer
Model json laravel accessor to convert to array
PHP Laravel