2 select的配合

select * from my_contacts;

select * from my_contacts where first_name='Anne';

在 '' (两个单引号)中添加 一个  '(单引号)
需要用转义字符
'Grover''s Mill'   '' 表示 '
'Grover\'s Mill'   \' 表示 '

结合查询and  同时处理两项查询
select location from doughnut_ratings
where type='plain_glazed' and rating=10;

比较运算符取得文本数据
select drink_name from drink_info
where drink_name>='L'
and  drink_name<='M'
这个查询返回名称首字母为'L'或位于其后的但要早于'M'的饮料

只要符合一项 ---- OR

 

is null 找到 null
因为没有东西等于null， 所以 =null 不会成功,null代表未定义的值
select drink_name from drink_info
where
calories is null;

 

like 关键字 结合通配符
select * from my_contacts
where location like '%CA';
查找以CA 结尾的值

between  
select drink_name from drink_info
where
calories between 30 and 60;

in 关键字 在集合中
select data_name from black_book
where
rating in('innovative','fabulous','delightful','pretty good');

not in 不在集合中
select data_name from black_book
where
rating not in('innovative','fabulous','delightful','pretty good');

not 一定紧接在where 后
select drink_name from drink_info
where not carbs between 3 and 5;

select data_name from black_book
where not data_name like 'A%'
and not data_name like 'B%';