php - ORM for mysql now() - Laravel 4

Question

我有下面的sql

select * from bids where deleted_at is  null 
and  publication_date <= now() and open_date >= now()   

我想用ORM写

   $bids = Bid::where('publication_date','<=','now()')->where('open_date','>=','now()')->get();

它不起作用，然后我重写如下

$bids=DB::select(DB::raw('select * from bids where deleted_at is  null and  publication_date <= now() and open_date >= now()'));

如何在 ORM 上编写上述查询，我认为 now() 有问题

Answer 1

您可以使用 whereRaw method :

$bids = Bid::whereRaw('publication_date <= now() and open_date >= now()')->get();