Level 1
There is no whereInYear() query builder, you can use whereIn('year', $years) or create a dynamic scopeInYear()
public function scopeInYear($query, $years)
{
return $query->whereIn('year', $years);
}
Dec 16, 2020
3
Level 6
Query WhereYear() WhereInYear()
in my query I am able to do
whereYear()
but i need something like
whereInYear()
how would you do it?
Level 6
it is birthday....something like.... 2010-01-01
->whereYear('birthday', $year)
Level 6
this seems to be working....
$query->whereIn( \DB::raw('year(birthday)'), request()->year );
Please or to participate in this conversation.