laravel requested
-
Please indicate how to optimize the request:
select * from (select * from `bron` where DATE('2015-12-14') between `start` and `end`)t1 where nomer = '2';
and implemented by designer
$bron_between2 = DB::table('bron') ->select(DB::raw("DATE('$date') between start and end")) ->where('nomer', $nomer)->get();
-
It's settled.
$bron_between= DB::table('bron') ->whereRaw("DATE('$date') between start and end") ->where('nomer', '=', $nomer->id) ->get();