正则表达式

+ 匹配一次及以上
* 匹配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%'