I need to convert this query into laravel query builder
select * from employee where(( age = 25 and salary = 20000) or (age =30 and salary = 30000))
-
what is your current attempt?Marcin Orlowski– Marcin Orlowski2018-08-14 06:07:19 +00:00Commented Aug 14, 2018 at 6:07
Add a comment
|
2 Answers
If you want to group where clauses you can nest them inside closures:
DB::table('employee')
->where(function ($query) {
$query->where('age', 25)->where('salary', 20000);
})
->orWHere(function ($query) {
$query->where('age', 30)->where('salary', 30000);
})
->get();
For more information have a look at Parameter Grouping in the documentation.
1 Comment
Sarita Sharma
can you please give me a reference or documentation link for this?
Can you try this,
$data = Model::where([["age", "25"],["salary", "20000"]])
->orWhere([["age", "30"],["salary", "30000"]])
->get();
