1.like

#包含某个字符 
select * from table where name like '李' or name like '王'; 
#以某个字符开头 
select * from table where name like '李%' or name like '王%'; 
#以某个字符结尾 
select * from table where name like '%李' or name like '%王';

2.regexp_like

#包含某个字符 
select * from table where regexp_like(name,'(李|王)') 
#以某个字符开头 
select * from table where regexp_like(name,'^(李|王)') 
#以某个字符结尾 
select * from table where regexp_like(name,'(李|王)$')