Laravel - Query Builder - Additional Where Clauses

whereBetween / orWhereBetween

The whereBetween method verifies that a column's value is between two values:

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

whereNotBetween / orWhereNotBetween

The whereNotBetween method verifies that a column's value lies outside of two values:

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

whereIn / whereNotIn / orWhereIn / orWhereNotIn

The whereIn method verifies that a given column's value is contained within the given array:

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

The whereNotIn method verifies that the given column's value is not contained in the given array:

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

If you are adding a large array of integer bindings to your query, the whereIntegerInRaw or whereIntegerNotInRaw methods may be used to greatly reduce your memory usage.

whereNull / whereNotNull / orWhereNull / orWhereNotNull

The whereNull method verifies that the value of the given column is NULL:

    
    $users = DB::table('users')
                    ->whereNull('updated_at')
                    ->get();
	

The whereNotNull method verifies that the column's value is not NULL:

    
    $users = DB::table('users')
                    ->whereNotNull('updated_at')
                    ->get();
	

whereDate / whereMonth / whereDay / whereYear / whereTime

The whereDate method may be used to compare a column's value against a date:

    
    $users = DB::table('users')
                    ->whereDate('created_at', '2016-12-31')
                    ->get();
	

The whereMonth method may be used to compare a column's value against a specific month:

    
    $users = DB::table('users')
                    ->whereMonth('created_at', '12')
                    ->get();
	

The whereDay method may be used to compare a column's value against a specific day of the month:

    
    $users = DB::table('users')
                    ->whereDay('created_at', '31')
                    ->get();
	

The whereYear method may be used to compare a column's value against a specific year:

    
    $users = DB::table('users')
                    ->whereYear('created_at', '2016')
                    ->get();
	

The whereTime method may be used to compare a column's value against a specific time:

    
    $users = DB::table('users')
                    ->whereTime('created_at', '=', '11:20:45')
                    ->get();
	

whereColumn / orWhereColumn

The whereColumn method may be used to verify that two columns are equal:

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

You may also pass a comparison operator to the whereColumn method:

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

You may also pass an array of column comparisons to the whereColumn method. These conditions will be joined using the and operator:

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