SQL之条件查询(高级数据过滤)

1、组合WHERE子句

　　1.1、AND操作符　

select
col_name
from
table_name
where
col_name = 'str'
and
col_name2 = 'str';

　　1.2、OR操作符

select
col_name
from
table_name
where
col_name = 'str'
or
col_name2 = 'str';

2、IN操作符

select
col_name
from
table_name
where
col_name
in 
("str", "str");

3、NOT操作符

　　where子句中的NOT操作符有且只有一个功能，就是否定其后所跟的任何条件

select
col_name
from
table_name
where
not
col_name = "str";