1.筛选lastname开头为B,where last_name like 'b%'
含有b的lastname ,where last_name like '%b%',
以b结尾则,where last_name like '%b'
y前面有五位数则,where last_name like '_____y'
y前面有b开头则,where last_name like 'b____y'
ps:%:any number of characters;
_:single character
练习:两个任务
答案及解说:
(1)注意,对于第一个任务,这里不能用IN,因为地址中不止有trail 和avenue
(2)select *
from customers
where phone like '%9'
(第三行where phone like '___-___-___9'也是可以的)