acb acdb ab ba
用like 'a b' ; 能检索出acb acdb ab;
想全检索出来acb acdb ab ba 怎么写
//a b 之间有空格
谢谢!!谢谢!!谢谢!!谢谢!!谢谢!!谢谢!!谢谢!!谢谢!!
用like 'a b' ; 能检索出acb acdb ab;
想全检索出来acb acdb ab ba 怎么写
//a b 之间有空格
谢谢!!谢谢!!谢谢!!谢谢!!谢谢!!谢谢!!谢谢!!谢谢!!
id number,
name varchar2(15)
);insert into like_test values(1,'acbtt');
insert into like_test values(2,'acb');
insert into like_test values(3,'acdb');
insert into like_test values(4,'yyazcbztt');
insert into like_test values(5,'a b');
insert into like_test values(6,'ab');
insert into like_test values(7,'ba');
insert into like_test values(8,'cacccbc');
insert into like_test values(9,'tttyya');
insert into like_test values(10,'yybzz');commit;----------------sql--------------------- select l.id,l.name
from like_test l
where l.name like '%a%' and l.name like '%b%';
-----------result-----------------------
ID NAME
---------- ---------------
1 acbtt
2 acb
3 acdb
4 yyazcbztt
5 a b
6 ab
7 ba
8 cacccbc8 rows selected
where instr(l.name,'a') > 0
and instr(l.name,'b') > 0;