echo "COLDEF|".json_encode(DB::select("SHOW COLUMNS FROM questions WHERE Field = 'qa_status'"))."\n"; foreach (DB::table('questions')->select('qa_status', DB::raw('count(*) c'))->groupBy('qa_status')->orderByDesc('c')->get() as $r) echo "VAL|".var_export($r->qa_status,true)."|".$r->c."\n";