Where Clauses: Additional Where Clauses

WhereBetween

$users = DB::table('users')
                    ->whereBetween('votes', [1, 100])->get();

WhereNotBetween

$users = DB::table('users')
                    ->whereNotBetween('votes', [1, 100])
                    ->get();

WhereIn / whereNotIn

$users = DB::table('users')
                    ->whereIn('id', [1, 2, 3])
                    ->get();
$users = DB::table('users')
                    ->whereNotIn('id', [1, 2, 3])
                    ->get();

WhereDate / whereMonth / whereDay / whereYear / whereTime

$users = DB::table('users')
                ->whereDate('created_at', '2016-12-31')
                ->get();
$users = DB::table('users')
                ->whereMonth('created_at', '12')
                ->get();
$users = DB::table('users')
                ->whereDay('created_at', '31')
                ->get();
$users = DB::table('users')
                ->whereYear('created_at', '2016')
                ->get();
$users = DB::table('users')
                ->whereTime('created_at', '=', '11:20:45')
                ->get();

WhereColumn

$users = DB::table('users')
                ->whereColumn('first_name', 'last_name')
                ->get();
$users = DB::table('users')
                ->whereColumn('updated_at', '>', 'created_at')
                ->get();
$users = DB::table('users')
                ->whereColumn([
                    ['first_name', '=', 'last_name'],
                    ['updated_at', '>', 'created_at']
                ])->get();

Where Clauses: Additional Where Clauses — Structure map

Clickable & Draggable!

Where Clauses: Additional Where Clauses — Related pages: