Group By created_by date - error in SQL syntax

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax

here is my SQL:

Tagin::latest(DB::raw("DATE_FORMAT(created_at, %Y-%m-%d) as date"))->where('venue_id',$id)

I just want to display one date and then multiple tagins for each date

ajohnson6494

5 years ago

Level 11

The latest() function simply sorts your data with the most recent record first. It takes an optional column name. It looks like you are trying to pass in part of a select statement, which will not work. Laravel Documentation

You could maybe do something like:

Tagin::where(DB::raw("created_at::date")), DB::raw("MAX(created_at::date)")->where('venue_id', $id)->get()

siangboon

5 years ago

Level 54

perhaps you need whereRaw / orWhereRaw instead of raw https://laravel.com/docs/8.x/queries#raw-methods

Please or to participate in this conversation.