17,377
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM KK WHERE FDZL LIKE '%花园%' or FDZL LIKE '%和园%' or FDZL LIKE '%花园%' or FDZL LIKE '%家园%' or FDZL LIKE '%兴园%' or FDZL LIKE '%轩园%' or FDZL LIKE '%怡园%'
这 后面的 FDZL LIKE 用 regexp_LIKE 用正则怎么写?
SELECT * FROM mytable WHERE REGEXP_LIKE(mycolumn, '[和花家兴轩怡]园');
SQL>
SQL> create table test(id int, name varchar(30));
Table created
SQL> begin
2 insert into test values(1,'XC花园DDD');
3 insert into test values(2,'X怡园DDD');
4 insert into test values(3,'XA天园DDD');
5 insert into test values(4,'ZX地园DDD');
6
7 end;
8 /
PL/SQL procedure successfully completed
SQL> col id format a10;
SQL> select * from test
2 where regexp_like(name, '花园|天园');
ID NAME
---------- ------------------------------
1 XC花园DDD
3 XA天园DDD
SQL> drop table test purge;
Table dropped
SQL>