select substring_index(substring_index(station,',',help_topic_id + 1),',',-1) as num
from
mysql.help_topic
where help_topic_id < length(station) - length(replace(station,',','')) + 1
Mysql将某一列的值根据指定字符拆分成列
最新推荐文章于 2023-06-29 15:08:56 发布