本文介绍了一种使用SQL进行复选框选项统计的方法，通过巧妙地利用substring_index函数结合join操作来实现对多个选择项的有效计数。此方法适用于处理包含多个用分隔符分隔的选项字段。
/**单选统计**/
SELECT syyou,count(syyou) from test_form_one group BY syyou/**复选统计**/
select substring_index(substring_index(a.race,'|',b.help_topic_id+1),'|',-1) as race,count(substring_index(substring_index(a.race,'|',b.help_topic_id+1),'|',-1))
from test_form_one a
join mysql.help_topic b
on b.help_topic_id < (length(a.race) - length(replace(a.race,'|',''))+1)
group BY substring_index(substring_index(a.race,'|',b.help_topic_id+1),'|',-1)
order by a.id;
截取的核心语句为：
select substring_index(substring_index(a.race,'|',b.help_topic_id+1),'|',-1) from test_form_one a
join mysql.help_topic b
on b.help_topic_id < (length(a.race) - length(replace(a.race,'|',''))+1)
order by a.id;
参考的文件地址：http://www.cnblogs.com/cenalulu/archive/2012/08/20/2647463.html
扫一扫
6149
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
