How to get the value of specific index inside an array column using mysql?

$reports = DB::table('attendance_report_details')
            ->select('*','project_hours[$index_id]')
            ->get();

I am passing index id to the function. Is there a way to do it like this?

Answer

Use the arrow operator (MySQL-only):

$reports = DB::table('attendance_report_details')
    ->select('*', DB::raw("project_hours->'$[".(int) $index_id."]'"))
    ->get();

Or its alias JSON_EXTRACT() (MySQL & MariaDB):

$reports = DB::table('attendance_report_details')
    ->select('*', DB::raw("json_extract(project_hours, '$[".(int) $index_id."]')"))
    ->get();