mysql进行分割后修改每个字符的内容再进行拼接

场景描述

在mysql 中 某个字段中有 112,223,3344,554 我们想将 其变成 11,22,33,55 应该怎么处理

处理sql：

SELECT 
GROUP_CONCAT(SUBSTR(SUBSTRING_INDEX( SUBSTRING_INDEX( a.old_business_type_code, ',', b.help_topic_id + 1 ), ',',- 1 ) ,1,9)) AS business_code,
a.id , a.old_business_type_code
FROM
	contract_work a  
INNER JOIN mysql.help_topic b ON b.help_topic_id < ( length( a.old_business_type_code ) - length( REPLACE ( a.old_business_type_code, ',', '' )) + 1 ) 
WHERE  a.old_business_type_code is not null 
GROUP BY a.id