CODEWITHSUNDEEP
phplaravellaravel-4query-builder
Matthieu
Matthieu

Reputation: 235

laravel 4 function query YEAR(column) get an error

I am making a simple query request with a where condition. I need to have in this condition the year of a date field, in SQL i use "YEAR(date)=2015" In laravel when i use it, i get an error because he didnt find the column.

$total_num_rows_y = DB::table('insatisfaction')
  ->select(DB::raw('COUNT(id) as total_num_rows_y'))
  ->where('foo', $foo->id_aj)
  ->where('YEAR(date)', '2015')
  ->get();

Could you help me?

Upvotes: 0

Views: 1182

Answers (2)

Daniel Renteria
Daniel Renteria

Reputation: 375

You can use whereYear

$total_num_rows_y = DB::table('insatisfaction')
  ->select(DB::raw('COUNT(id) as total_num_rows_y'))
  ->where('foo', $foo->id_aj)
  ->whereYear('date','=',2015)
  ->get();

Upvotes: 0

tomprouvost
tomprouvost

Reputation: 115

Let's try :

$total_num_rows_y = DB::table('insatisfaction')
   ->select(DB::raw('COUNT(id) as total_num_rows_y'))
   ->where('foo', $foo->id_aj)
   ->where(DB::raw('YEAR(start)'), '=', date('Y'));
   ->get();

Upvotes: 1

Related Questions