Make a query where a relationship matches all elements of an array

How to make a query that will only return the Foo elements containing all the given colors (from $colors_array) in its relationship colors, and not the results containing one of the listed colors like below ?

$colors_array = ['red', 'green', 'blue'];

Foo::with('colors')
->whereHas(
    'colors',
    function ($query) use ($colors_array) {
        if ($filters) {
            $query->whereIn('name', $colors_array);
        }
    }
)

MichalOravec

5 years ago

Best Answer

Level 75

$colors_array = ['red', 'green', 'blue'];

Foo::with('colors')->whereHas('colors', function ($query) use ($colors_array) {
    $query->distinct()->whereIn('name', $colors_array);
}, '=', count($colors_array));

2 likes

devondahon

5 years ago

Level 3

@michaloravec That's exactly what I needed, thanks a lot !

However I'm surprised how slow the queries are. Is there any faster alternative ?

Please or to participate in this conversation.