MySQL表中分割查询
表,如图
SQL语句
SELECT
t.id, t.bus_id,
(SELECT group_concat(tb.bus_num)
FROM tra_bus tb
WHERE find_in_set(tb.id,t.bus_id) ) busName
FROM tra_plan t
SELECT
t.id, t.bus_id,
(SELECT group_concat(tb.bus_num)
FROM tra_bus tb
WHERE find_in_set(tb.id,t.bus_id) ) busName
FROM tra_plan t
转载于:https://my.oschina.net/u/2524145/blog/544237