msql 通过 (,)拼接的字段进行行转列 一行变多行
SELECT
projectIds,
substring_index(substring_index(contract.projectIds,',',b.help_topic_id + 1),',' ,- 1) projectId
FROM
erp_contract contract
JOIN mysql.help_topic b
ON b.help_topic_id < (length(contract.projectIds) - length(REPLACE (contract.projectIds, ',', '')) + 1)