题解 | 话题的分布情况
select substring_index(subject_set, ',', 1) subject_id1,COUNT(*) cnt from comment_detail where find_in_set('1002', subject_set) group by subject_id1 order by subject_id1
select substring_index(subject_set, ',', 1) subject_id1,COUNT(*) cnt from comment_detail where find_in_set('1002', subject_set) group by subject_id1 order by subject_id1
相关推荐