mysql中的if语句遇到统计count group by的时候会出现不准确的情况,原因是分组后if条件的结果以第一条为准,不会跟着分组 例如: SELECT t1.*,t2.nick_name,t2.avatar,IF(t1.user_id=104080,1,0) AS is_owner, IF(t4.user_id=104080,t4.vote_val,'N') AS is_voted, IF(t7.user_id=104080,1,0) AS is_collected FROM answe