Laravel Eloquent Query Using WHERE with OR AND OR?

by

Make use of Logical Grouping (Laravel 7.x/4.2). For your example, it’d be something like this:

Model::where(function ($query) {
    $query->where('a', '=', 1)
          ->orWhere('b', '=', 1);
})->where(function ($query) {
    $query->where('c', '=', 1)
          ->orWhere('d', '=', 1);
});

More Related Contents:

  1. How to Create Multiple Where Clause Query Using Laravel Eloquent?
  2. Get Specific Columns Using “With()” Function in Laravel Eloquent
  3. How do I get the query builder to output its raw SQL query as a string?
  4. Creating and Update Laravel Eloquent
  5. How to sort a Laravel query builder result by multiple columns?
  6. Get the Query Executed in Laravel 3/4
  7. Laravel one to many relation with a one to one relation
  8. Get the Last Inserted Id Using Laravel Eloquent
  9. Bulk Insertion in Laravel using eloquent ORM
  10. How to insert multiple rows from a single query using eloquent/fluent
  11. Laravel – Eloquent or Fluent random row
  12. Add a custom attribute to a Laravel / Eloquent model on load?
  13. How to alias a table in Laravel Eloquent queries (or using Query Builder)?
  14. Laravel Eloquent Sum of relation’s column
  15. What does “Mass Assignment” mean in Laravel?
  16. Laravel 5.2 – Use a String as a Custom Primary Key for Eloquent Table becomes 0
  17. Laravel 4: how to “order by” using Eloquent ORM [duplicate]
  18. How to exclude certains columns while using eloquent
  19. How to alias the name of a column in Eloquent
  20. Laravel 5 hasMany relationship on two columns
  21. Laravel $q->where() between dates
  22. How to Make Laravel Eloquent “IN” Query?
  23. Laravel Eloquent – Attach vs Sync
  24. Update without touching timestamps (Laravel)
  25. laravel collection to array
  26. Laravel Eloquent sort by relation table column
  27. Eloquent Parent-Child relationship on same model
  28. Natural ORDER in Laravel Eloquent ORM
  29. Eloquent groupBy make “SQLSTATE[42000]” with valid SQL query in Laravel 5.3
  30. Laravel Eloquent update just if changes have been made

Leave a Comment