php - 转换 laravel Eloquent 查询

Question

你的任何人都可以帮助我如何转换像这个查询

SELECT * FROM prize_frequency WHERE SYSDATE() BETWEEN start_time AND end_time

标签： phplaravel-5

Answer 1

原始查询

DB::table('prize_frequency')->whereRaw('SYSDATE() BETWEEN start_time AND end_time')->get();

你可以使用 eloquent 来阅读

模型：

PriceFrequency - start_time - end_time

$priceFrequency = \App\PriceFrequency::where('start_time', '>=', now())->where('end_time', '<=', now())->get();