/PHP/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

7 votes235 views3 answers
Laravel data type
PHP
0 vote250 views1 answer
Wordpress max post revision
PHP
1 vote249 views1 answer
Composer deploy production
PHP
0 vote264 views1 answer
Laravel store multiple files
PHP Laravel
3 votes275 views2 answers
Laravel adding condition to relation
PHP Laravel
2 votes228 views1 answer
Wordpress check user against user roles
PHP
0 vote236 views1 answer
Wordpress exclude current post from loop
PHP
32 votes222 views6 answers
Carbon diff
PHP
7 votes283 views3 answers
How to show validation error in laravel blade
PHP Laravel
0 vote225 views1 answer
Php get url after question mark
PHP