Laravel Query Builder Query

Question

I want to make a query like this

SELECT * FROM batches WHERE id = 20 AND status = 3 OR status = 8

I tried following query but it returning me all records with status = 8

Batch::where('id', 20)->where('status','3')->orwhere('status','8');

What mistake did I make?

Thanks in advance!

Thomas Kim · Accepted Answer · 2015-11-17 20:14:06Z

2

you can use whereIn

Batch::where('id', 20)->whereIn('status', [3,8]);

edited Nov 17, 2015 at 20:14

Thomas Kim

16k2 gold badges55 silver badges43 bronze badges

answered Nov 17, 2015 at 6:17

Karan

2,1122 gold badges23 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Kiran Subedi · Accepted Answer · 2015-11-17 06:39:47Z

1

You can use Advanced Wheres

 Batch::where('id', 20)->where(function($query) use ($staus){
       foreach($status as $stat){
           $query->orWhere('status','=',$stat);
       }
 })->get();

edited Nov 17, 2015 at 6:39

answered Nov 17, 2015 at 6:25

Kiran Subedi

2,2844 gold badges20 silver badges35 bronze badges

1 Comment

Thomas Kim Over a year ago

PHP methods and functions are case insensitive.

Collectives™ on Stack Overflow

Laravel Query Builder Query

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related