我也求一SQL语句!所有站点放在一字段时用空格隔开！现在查询其中两站点的SQL语句

Question

SQL> select * from test;AA                                                                              
--------------------------------------------------                              
12345678                                                                        
245678                                                                          
12578                                                                           取出从2到7的字符串
SQL> select substr(aa,instr(aa,'2'),instr(aa,'7')-instr(aa,'2')+1) from test
  2  where
  3  aa like '%2%7%';SUBSTR(AA,INSTR(AA,'2'),INSTR(AA,'7')-INSTR(AA,'2'                              
--------------------------------------------------                              
234567                                                                          
24567                                                                           
257

Answer 1

select 线路 from bus_path where 上行经过车站 like "%大柏树&" and 上行经过车站  like  "%新华村%"

Answer 2

存储方法有问题,改用链表
线路 方向 站 下一站
然后用connect by来查找

Answer 3

select 线路 from bus_path where instr(上行经过车站,'大柏树')>0 and instr(上行经过车站,'新华村')>0