stack stack - 1 month ago 6
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
where('1')
doesn't work.

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

Answer

Use all():

TBname::all();

Or get():

TBname::get();