Is it possible to group where clauses in Eloquent?

Yes, it is possible for example you can do something like:

User::where('username','john doe')
    ->where(function($query)
    {
        $query->where('age','>',30)
        ->orWhere('email','=','johndoe@xyz.com');
    })
    ->toSql();

The above statements will generate the following SQL:

select * from `users` where `username` = ? and (`age` > ? or `email` = ?)

Thanks man!

Thanks.. Helped :)

Helped here too... thanks!

Thanks. Just the example I was looking for.

It does show this in the userguide as well: https://laravel.com/docs/5.6/queries#parameter-grouping

Remember all query builder methods are also available to Eloquent models, as Eloquent is built on top of the query builder.

It worked for me by this code:

public static function seachFiles($q, $categoryId)
{

    return static::where('category_id', '=' ,$categoryId)
                    ->where(function ($query) use ($q) {
                        $query->where('file_name', 'LIKE', "%$q%")
                                ->orWhere('file_code', 'LIKE', "%$q%")
                                ->orWhere('description', 'LIKE', "%$q%");
                    })
                    ->get();
}

hope this helps.

Thanks a lot..

Thanks

Thanks!