How to Create Multiple Where Clause Query Using Laravel Eloquent?

How to Create Multiple Where Clause Query Using Laravel Eloquent?


In Laravel Eloquent, you can create multiple where clause queries using the "where" method on the query builder instance multiple times. Here is an example:

        $users = DB::table('users')
                ->where('name', 'like', '%john%')
                ->orWhere('name', 'like', '%jane%')
                ->get();

You can also chain multiple where clause conditions to make your query more complex:

        $users = DB::table('users')
                ->where('name', 'like', '%john%')
                ->orWhere(function ($query) {
                    $query->where('name', 'like', '%jane%')
                          ->where('email', 'like', '%example.com%');
                })
                ->get();
Previous Post Next Post

Contact Form