How to Create Multiple Where Clause Query Using Laravel Eloquent?

Question

How to Create Multiple Where Clause Query Using Laravel Eloquent?

I'm using the Laravel Eloquent query builder and I have a query where I want a WHERE clause on multiple conditions. It works, but it's not elegant.

Example:

$results = User::where('this', '=', 1)

    ->where('that', '=', 1)

    ->where('this_too', '=', 1)

    ->where('that_too', '=', 1)

    ->where('this_as_well', '=', 1)

    ->where('that_as_well', '=', 1)

    ->where('this_one_too', '=', 1)

    ->where('that_one_too', '=', 1)

    ->where('this_one_as_well', '=', 1)

    ->where('that_one_as_well', '=', 1)

    ->get();

Is there a better way to do this, or should I stick with this method?

php laravel

4 years ago by Amit8z4mc

2 Answers

Login / Signup to Answer the Question.

Login Signup

**Bharatgxwzm** · Answer 1 · 2021-08-10T11:42:47

You can use subqueries in anonymous function like this:

 $results = User::where('this', '=', 1)

       ->where('that', '=', 1)

       ->where(

           function($query) {

             return $query

                    ->where('this_too', 'LIKE', '%fake%')

                    ->orWhere('that_too', '=', 1);

            })

            ->get();

**sandhya6gczb** · Answer 2 · 2021-08-18T14:51:14

In Laravel 5.3 (and still true as of 7.x) you can use more granular wheres passed as an array:



$query->where([

    ['column_1', '=', 'value_1'],

    ['column_2', '<>', 'value_2'],

    [COLUMN, OPERATOR, VALUE],

    ...

])

you can pass an array to where

As long as you want all the wheres use and operator, you can group them this way:



$matchThese = ['field' => 'value', 'another_field' => 'another_value', ...];

// if you need another group of wheres as an alternative:



$orThose = ['yet_another_field' => 'yet_another_value', ...];

Then:



$results = User::where($matchThese)->get();



// with another group

$results = User::where($matchThese)

    ->orWhere($orThose)

    ->get();

The above will result in such query:



SELECT * FROM users

  WHERE (field = value AND another_field = another_value AND ...)

  OR (yet_another_field = yet_another_value AND ...)

C TUTORIAL

C PROGRAMS

INTERVIEW TESTS

EXECUTE CODE

C++ TUTORIAL

C++ PROGRAMS

INTERVIEW TESTS

EXECUTE CODE

PYTHON TUTORIAL

PYTHON HOW TOS

INTERVIEW TESTS

EXECUTE CODE

JAVA TUTORIAL

JAVA CODE EXAMPLES

SPRING TUTORIAL

MORE IN JAVA

COMPUTER ARCHITECTURE

COMPUTER NETWORK

OPERATING SYSTEM

DBMS & SQL

PL/SQL

MongoDB

EXECUTE SQL

ANDROID DEVELOPMENT

GO LANGUAGE

LINUX

DOCKER

HTML TAGS (A to Z)

CSS REFERENCES

SASS/SCSS

KOTLIN

GAME DEVELOPMENT

PHP

GIT GUIDE

JAVASCRIPT

ADVANCED DSA

How to Create Multiple Where Clause Query Using Laravel Eloquent?

2 Answers

Login / Signup to Answer the Question.