MySQL.之 一行内容转换多行
时间：2021-07-01 10:21:17
帮助过：3人阅读
SELECT
2 SUBSTRING_INDEX( SUBSTRING_INDEX( C.cds_value,
‘,‘, G.ID ),
‘,‘,
- 1 ) IDS
3 FROM
4 cds_var C
5 JOIN var_index G
ON G.ID
<= ( LENGTH( C.cds_value )
- LENGTH(
REPLACE ( C.cds_value,
‘,‘,
‘‘ ) )
+ 1 )
6 WHERE
7 C.cds_code
= ‘CDS000023‘
8 AND C.cds_key
= ‘CHANGE_DATA_IDS‘;
MySQL.之 一行内容转换多行
标签：and rom join img hang font bst pre sel
