/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

5 votes202 views6 answers
Laravel 8 auth
PHP Laravel
0 vote263 views1 answer
Get deleted value laravel
PHP Laravel
0 vote209 views1 answer
How to share count of things to sidebar in laravel
PHP Laravel
0 vote261 views1 answer
Composer require rtconner/laravel-tagging
PHP Laravel
0 vote210 views1 answer
Laravel Deployment to google cloud app engine flexible environment app.yaml file
PHP Laravel
0 vote230 views1 answer
Combine 2 columns search query laravel
PHP Laravel
0 vote203 views1 answer
Laravel get query in normal sql without bindings
PHP Laravel
61 votes543 views6 answers
Cache clear in laravel
PHP Laravel
0 vote214 views1 answer
Laravel array search blade
PHP Laravel
62 votes528 views6 answers
Clear cache laravel
PHP Laravel