Select all columns with an asterisk when joining tables with Eloquent or Query Builder.

Question

How can I select all columns from one of multiple concatenated tables?

DB::table('table as t')->select('t*');

asterix doesn't seem to work in Laravel? Thank!

+3

Hobby99 09 Sep '14 at 16:30

2 answers

Try DB::table('table')->get();

0

Helder lucas 09 Sep 14 at 16:45

Jarek Tkaczyk · Accepted Answer · 2014-09-09T19:20:47+0000

Yes it works, but you are wrong. Try this (note .

):

DB::table('table as t')->select('t.*');