正则表达式

+ 匹配一次及以上
* 匹配0次及以上


SQL> select * from a1;

NAME
----------
abc
abcdef
abcccc

SQL> select * from a1 where name like '%abc%';

NAME
----------
abc
abcdef
abcccc



SQL> select * from a1 where regexp_like(name,'abc');

NAME
----------
abc
abcdef
abcccc

SQL>  select * from a1 where regexp_like(name,'^abc$');

NAME
----------
abc

'abc' 等价于 like '%abc%'


SQL> select * from a1;

NAME
----------
abc
abcdef
abcccc
ab

SQL> select * from a1 where regexp_like(name,'abc+');

NAME
----------
abc
abcdef
abcccc


SQL>  select * from a1 where regexp_like(name,'z*');

NAME
----------
abc
abcdef
abcccc
ab

SQL> select * from a1 where regexp_like(name,'1*');

NAME
----------
abc
abcdef
abcccc
ab
匹配0个或者多个1


select * from a1 where regexp_like(name,'16*');
相当于

select * from a1 where name like '%1%'

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!