laravel的数据库操作方式(5)

1.附加的Where条款
whereBetween / orWhereBetween

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

whereNotBetween / orWhereNotBetween

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

whereIn / whereNotIn / orWhereIn / orWhereNotIn

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

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

注意：假如数组中加入大量的整型查询，whereInterInRaw或者whereInterNotInRaw方法可以更好的减少内存的使用

whereNull / whereNotNull / orWhereNull / orWhereNotNull

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

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

whereDate / whereMonth / whereDay / whereYear / whereTime

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

$users = DB::table('users')
                ->whereMonth