Laravel eloquent select data only specific term

Question

I have a data table with several status condition. For example:
status = "pending","approved","rejected".

How to use eloquent query to select the column for status "pending", "rejected" only?

http://stackoverflow.com/questions/19325312/how-to-create-multiple-where-clause-query-using-laravel-eloquent — victor, May 11 '17 at 14:19

score 1 · Accepted Answer · answered May 11 '17 at 14:22

1

If you need to select data where status is pendning or rejected, use whereIn():

Model::whereIn('status', ['pending', 'rejected'])->get();

Or orWhere():

Model::where('status', 'pending')->orWhere('status', 'rejected')->get();

answered May 11 '17 at 14:22

Alexey Mezenin

1 Answers1