stack stack - 1 year ago 58
MySQL Question

How can I select all table's rows?

I need to get all rows of the table. Currently I do that like this:

$all_rows = TBname::where('id', '>', '0')->get();

As you see, I've used
id > 0
condition to select all rows. But I think this isn't a standard way. In pure SQL I can use
. . . where 1
. But in Laravel
doesn't work.

Anyway, what's the most standard approach to select (and fetch) all rows in Laravel?

Answer Source

Use all():


Or get():

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download