Laravel multilpes where Like with array

Question

I need query of my model with method (where) and using LIKE to find results;

Its my code:

public function scopeTags($query, $tags)
{
    /*
     * random = [ 'tag1', 'tag2', 'tag3', ...]
     */
    $random = $tags[rand(0, count($tags) - 1)];
    return $query->where('tags', 'LIKE', "%{$random}%");
}

I need something like that:

public function scopeTags($query, $tags)
{
    /*
     * random = [ 'tag1', 'tag2', 'tag3', ...]
     */
    foreach($tags as $tag) {
        $random[] = "%{$tag}%";
    }
    return $query->where('tags', 'LIKE', $random);
}

What's the best way to do it?

Felippe Duarte · Accepted Answer · 2017-08-15 21:02:27Z

1

You need to add a extra where function call for each tag:

public function scopeTags($query, $tags)
{
    /*
     * random = [ 'tag1', 'tag2', 'tag3', ...]
     */
    foreach($tags as $tag) {
        $query->where('tags', 'LIKE', "%{$tag}%"); //this will be a AND
        //$query->OrWhere('tags', 'LIKE', "%{$tag}%"); //this will be a OR
    }
    return $query;
}

or if you need to simulate WHERE (tags like '%tag1%' AND tags like'%tag2%' AND ...) AND (something else) with parenthesis:

public function scopeTags($query, $tags)
{
    return $query->where(function($q) use($tags) {
        foreach($tags as $tag) {
            $q->where('tags', 'LIKE', "%{$tag}%"); //this will be a AND
            //$q->OrWhere('tags', 'LIKE', "%{$tag}%"); //this will be a OR
        }
        return $q;
    });
}

edited Aug 15, 2017 at 21:02

answered Aug 15, 2017 at 20:56

Felippe Duarte

15.2k2 gold badges27 silver badges29 bronze badges

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

Collectives™ on Stack Overflow

Laravel multilpes where Like with array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related