Answers for "AND-OR-AND + brackets with Eloquent"

TypeScript

1

AND-OR-AND + brackets with Eloquent

//mysql query be like this
// ... WHERE (gender = 'Male' and age >= 18) or (gender = 'Female' and age >= 65)

//Eloquent query is
// ...
$q->where(function ($query) {
    $query->where('gender', 'Male')
        ->where('age', '>=', 18);
})->orWhere(function($query) {
    $query->where('gender', 'Female')
        ->where('age', '>=', 65);	
})
//@sujay

Posted by: Guest on October-16-2020

Code answers related to "AND-OR-AND + brackets with Eloquent"

Code answers related to "TypeScript"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#