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"

 

show tables like "temp*";