1、原始数据演示
SELECT
a.maintenanceUnitCode ,
a. contractName ,
substring_index(substring_index(a.elevatorArr ,',',b.help_topic_id + 1),',' ,- 1) AS ORIGINALID ,
'2' as DWLX
FROM
ele_contract_main a
JOIN mysql.help_topic b ON b.help_topic_id < (length(a.elevatorArr) - length(REPLACE (a.elevatorArr, ',', '')) + 1)
2、处理之后