/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 votes206 views1 answer
How to add new column in table laravel
PHP Laravel
11 votes183 views5 answers
Laravel model transaction
PHP Laravel
0 vote187 views1 answer
Seprate day and year from laravel to timestamp
PHP Laravel
9 votes167 views6 answers
Pluck laravel
PHP Laravel
12 votes171 views4 answers
Laravel return redirect to named route
PHP Laravel
0 vote158 views1 answer
Laravel api get controller
PHP Laravel
0 vote188 views1 answer
Laravel eloquent relationships count
PHP Laravel
0 vote177 views2 answers
How do we calculate average in laravel 8
PHP Laravel
8 votes183 views6 answers
Session in laravel
PHP Laravel
3 votes191 views6 answers
Last insert id in laravel
PHP Laravel