mysql 搜索某个字段中某个值出现的次数

$evaluations = Evaluation::where('lesson_id', 'in', array_unique($lesson_ids))->group('lesson_id')
            ->column('count(id) as advisenum, SUM(CASE is_early WHEN "1" THEN 1 ELSE 0 END) is_early, SUM(CASE is_count WHEN "1" THEN 1 ELSE 0 END) is_count, SUM(CASE is_check_phone WHEN "1" THEN 1 ELSE 0 END) is_check_phone, SUM(CASE is_improper_remarks WHEN "1" THEN 1 ELSE 0 END) is_improper_remarks, lesson_id, count(suggest) as suggest, SUM(score) as score, SUM(gain) as gain', 'lesson_id');//lesson_id可以去重

在mysql中语句使用SUM(Field WHEN “VALUE” 1 ELSE 0 END)
***Field***为字段名称
***VALUE***为字段值
最后查询的就是在数据表中field字段里的value值出现了几次