It's been discussed that one can use the following code to pass multiple WHERE clauses to single where() method in Laravel's Eloquent:

$condition = array('field_1' => 'value_1', 'field_2' => 'value_2');
$users = User::where($conditon)->get();

The code above simply chains the array's key-value pairs with AND, generating this:

SELECT * FROM `users` WHERE field_1 = value_1 AND field_2 = value_2;


The key-value pairs above base on equality. Is it possible to use the same implementation for strings, where instead of = we use LIKE?

Abstract example of what I mean:

$condition = array(
                array('field_1', 'like', '%value_1%'),
                array('field_2', 'like', '%value_2%')
$users = User::where($conditon)->get();

This can for sure be done with multiple ->where(...) usage. Is it doable with passing a single array, though?


No not really. But internally Laravel just does it with a loop as well.


if (is_array($column))
    return $this->whereNested(function($query) use ($column)
        foreach ($column as $key => $value)
            $query->where($key, '=', $value);
    }, $boolean);

I suggest you do something like this:

$condition = array(
                'field_1' => '%value_1%',
                'field_2' => '%value_2%'

$users = User::where(function($q) use ($condition){
    foreach($condition as $key => $value){
        $q->where($key, 'LIKE', $value);
  • 15
Reply Report

Warm tip !!!

This article is reproduced from Stack Exchange / Stack Overflow, please click

Trending Tags

Related Questions