MySQL.之 一行内容转换多行
标签：and rom join img hang font bst pre sel
MySQL.之 一行内容转换多行
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‘;