对用逗号分隔的字段进行统计

最新资讯 2022/3/21 14:56:09 测试文章如需删除请发送地址至邮箱:809451989@qq.com

SELECT count(1) as count,aa.PUB_ORG_ID 
FROM(SELECT SUBSTRING_INDEX( SUBSTRING_INDEX( a.PUB_ORG_ID, ',', help_topic_id + 1 ), ',',- 1 ) AS PUB_ORG_ID  FROM mysql.help_topic m,pm_achievements a  WHERE help_topic_id < LENGTH( a.PUB_ORG_ID ) - LENGTH( REPLACE ( a.PUB_ORG_ID, '', '' ) ) + 1 
	) AS aa 
WHERE
	aa.PUB_ORG_ID IS NOT NULL 
GROUP BY
	aa.PUB_ORG_ID 
ORDER BY
	aa.PUB_ORG_ID;