mysql字符串切割转为一个单列多行数据
目标:
有如下字符串:
T210706092@T210706091@T210706090@T210706089
如果需要转为单列多行格式:
SELECT
SUBSTRING_INDEX( SUBSTRING_INDEX( a.`deliverCodes`, '@', b.help_topic_id + 1 ), '@', - 1 ) AS deliverCode
FROM
( SELECT 'T210706092@T210706091@T210706090@T210706089' AS deliverCodes ) AS a
JOIN mysql.help_topic AS b ON b.help_topic_id < ( LENGTH( a.`deliverCodes` ) - LENGTH( REPLACE ( a.`deliverCodes`, '@', '' ) ) + 1 )
注:
分隔符:@,可用变量替换
字符串:T210706092@T210706091@T210706090@T210706089 ,可用变量替换
关注微信关注公众号分享更多知识与内容!