Using a single array to pass multiple WHERE conditions (with LIKE)

Question

Theory

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;

Problem

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?

Adam Ramadhan · Accepted Answer · 2016-07-20 06:12:20Z

16

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

Illuminate\Database\Query\Builder@where

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);
    }
})->get();

edited Jul 20, 2016 at 6:12

Adam Ramadhan

22.9k28 gold badges88 silver badges126 bronze badges

answered Jan 17, 2015 at 21:33

lukasgeiter

154k29 gold badges349 silver badges280 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

lesssugar Over a year ago

That, indeed, looks like the only way to currently do it the Laravel way. Thanks a lot.

lukasgeiter Over a year ago

You're welcome. And thanks for the edit, copy pasted a bit to fast ;)

Glen Over a year ago

Just to add incase this happens to someone else, make sure you add % around the value as it won't work otherwise!

user1204214 Over a year ago

One can also use orWhere if they want OR instead of AND in the query

Collectives™ on Stack Overflow

Using a single array to pass multiple WHERE conditions (with LIKE)

Theory

Problem

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

Theory

Problem

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related