其中一种写法如下,你可以自己改写成其它的多种写法。select distinct a.车次ID From tb_transfer a Inner join tb_transfer b on a.车次ID=b.车次ID Where a.经过的车站='广州' And b.经过的车站='长沙'
select a.车次ID from tb_transfer a join (SELECT 车次ID,Group_concat(经过的车站) as name FROM tb_transfer Group by 车次ID) b on a.车次ID=b.车次ID where b.name like '%广州%' and b.name like '%长沙%' group by a.车次ID
From tb_transfer a Inner join tb_transfer b on a.车次ID=b.车次ID
Where a.经过的车站='广州' And b.经过的车站='长沙'
select a.车次ID from tb_transfer a join (SELECT 车次ID,Group_concat(经过的车站) as name FROM tb_transfer Group by 车次ID) b on a.车次ID=b.车次ID
where b.name like '%广州%' and b.name like '%长沙%'
group by a.车次ID