/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

9 votes297 views3 answers
Image validate in laravel validater
PHP Laravel
0 vote268 views3 answers
Laravel select default old value
PHP Laravel
0 vote254 views1 answer
How to merge 2 laravel eloquent records
PHP Laravel
0 vote267 views1 answer
Export laravel path fedora
PHP Laravel
0 vote262 views1 answer
Laravel has one of many relationship
PHP Laravel
0 vote265 views4 answers
Installing bootstrap ui in laravel app
PHP Laravel
0 vote279 views1 answer
Access denied for user 'accessor access'@'localhost' (using password: NO) cpanel laravel
PHP Laravel
12 votes275 views6 answers
Laravel model where
PHP Laravel
0 vote308 views4 answers
Image Upload in Laravel
PHP Laravel
2 votes265 views1 answer
Laravel string key
PHP Laravel