laravel wherehas

1$users = User::whereHas('posts', function($q){
2    $q->where('created_at', '>=', '2015-01-01 00:00:00');
3})->get();
4// only users that have posts from 2015 on forward are returned
5

1use Illuminate\Database\Eloquent\Builder;
2
3// Retrieve posts with at least one comment containing words like foo%...
4$posts = App\Post::whereHas('comments', function (Builder $query) {
5    $query->where('content', 'like', 'foo%');
6})->get();
7
8// Retrieve posts with at least ten comments containing words like foo%...
9$posts = App\Post::whereHas('comments', function (Builder $query) {
10    $query->where('content', 'like', 'foo%');
11}, '>=', 10)->get();

1For example, a blog post may have an infinite number of comments. And a single
2comment belongs to only a single post  
3
4class Post extends Model
5{
6    public function comments()
7    {
8        return $this->hasMany('App\Models\Comment');
9    }
10}
11
12class Comment extends Model
13{
14    public function post()
15    {
16        return $this->belongsTo('App\Models\Post');
17    }
18}

1// Detach a single role from the user...
2$user->roles()->detach($roleId);
3
4// Detach all roles from the user...
5$user->roles()->detach();

1use Illuminate\Database\Eloquent\Builder;
2
3// Retrieve posts with at least one comment containing words like code%...
4$posts = Post::whereHas('comments', function (Builder $query) {
5    $query->where('content', 'like', 'code%');
6})->get();
7
8// Retrieve posts with at least ten comments containing words like code%...
9$posts = Post::whereHas('comments', function (Builder $query) {
10    $query->where('content', 'like', 'code%');
11}, '>=', 10)->get();

1                ->whereHas('translation', function ($query) use ($name){
2                    $query->where('name', 'like', $name);
3                }, '>=', 10)
4