like

select sname from teacher where sname like "q%"
select sname from teacher where sname like "%an%"
select sname from teacher where sname like "%ang"

转载于:https://www.cnblogs.com/hapyygril/p/11073770.html