Group by month producing error in laravel controller
I am trying to execute mysql query
SELECT COUNT( * ) FROM `Mytable` WHERE `col1` = 'value' GROUP BY MONTH(Date_time)
Laravel statement for the same is :
DB::table('Mytable')->where('col1','value')->GroupBy(MONTH('Date_time'))->count();
As query is fine but getting error :
Call to undefined function App\Http\Controllers\MONTH()
Any suggestion will be helpful
Best answer :
Instead of:
->GroupBy(MONTH('Date_time'))
try
->groupBy(DB::raw("MONTH('Date_time')"))
as MONTH() is a mysql function, not laravel function.
source :http://stackoverflow.com/questions/41460359/group-by-month-producing-error-in-laravel-controller
COMMENTS