MySQL 字段值按照分隔符拆分成列（行转列）

拆分前：

拆分后：

 

SQL：

WITH RECURSIVE planting_situation AS (
	SELECT 
		dist_code, dist_name,
		substr(concat(planting_varieties, '、'), 1, instr(concat(planting_varieties, '、'), '、') - 1) planting_varieties,
		substr(concat(planting_varieties, '、'), instr(concat(planting_varieties, '、'), '、') + 1) str
	FROM t_big_mushroom_planting_situation tbmps 
	UNION ALL
	SELECT 
		dist_code, dist_name,
		substr(str, 1, instr(str, '、') - 1) planting_varieties,
		substr(str, instr(str, '、') + 1) str
	FROM planting_situation
	WHERE instr(str, '、') > 0
)
SELECT * FROM planting_situation
ORDER BY dist_code