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,'(李|王)$')