Forum Get an user who has specific relationships

luddinus

posted 10 years ago

Database Eloquent

Last updated 2 years ago.

jarektkaczyk

replied 10 years ago

Solution

You need where in and having count(distinct .. ) mix in SQL (MySQL). You can also do it with has in some cases. Show the relation and the tables.

Last updated 2 years ago.

luddinus

replied 10 years ago

Well, this is the solution (thx to jarektkaczyk)

$countries = [1,5,9];

User::whereHas('countries', function ($q) use ($countries) {
  $q->whereIn('users_countries.country_id', $countries);
}, '=', count($countries) )->get();

I asked the same in stackoverflow if anyone is interested: http://stackoverflow.com/questions/24961783/laravel-get-an-user-who-has-specific-relationships

Last updated 2 years ago.