SELECT
substring_index(
substring_index(
a.station_ids,
',',
b.help_topic_id + 1
),
',' ,- 1
) AS station_ids
FROM
base_line a
JOIN mysql.help_topic b ON b.help_topic_id < (
length(a.station_ids) - length(
REPLACE (a.station_ids, ',', '')
) + 1
)
mysql逗号隔开的列分开查询
最新推荐文章于 2023-06-09 11:55:34 发布