场景描述
在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