Laravel 查询构建器中的 MySQL YEAR() 等效项

MySQL YEAR() equivalent in Laravel query builder

提问by Dadan Hamdani

With MySQL, I can use the YEAR()function like this to filter by the year of a date field in a WHEREclause:

使用 MySQL，我可以使用这样的YEAR()函数来过滤WHERE子句中日期字段的年份：

SELECT noworkorder FROM workorders WHERE YEAR(date)=2015;

In Laravel, I can of course achieve the same thing with a raw expression:

在 Laravel 中，我当然可以使用原始表达式实现相同的目的：

$data = DB::table('workorders')
       ->select('noworkorder')
       ->where(DB::raw('YEAR(date)=2015'))
       ->orderby('noworkorder', 'desc')
       ->get();

But is there a way to do this without raw expressions?

但是有没有办法在没有原始表达式的情况下做到这一点？

回答by Thomas Kim

The query builder has a whereYearmethod:

查询构建器有一个whereYear方法：

$data = DB::table('workorders')
   ->select('noworkorder')
   ->whereYear('date', '=', 2015)
   ->orderby('noworkorder', 'desc')
   ->get();