相关符号筛选
= 等于 >大于 <小于
!= or <> 不等于
!< 不小于
!> 不大于
between and ,介于
is null ,空值
select prod_name, prod_price
from products
where prod_price = 3.49; -- 按条件筛选数据
# 检查单个值
select prod_name, prod_price
from products
where prod_price <= 10;
# 筛选不匹配的值
select vend_id, prod_name
from products
where vend_id <> 'DLL01';
# 范围值检查
select prod_name, prod_price
from products
where prod_price between 5 and 10;
# 检查是否存在空值, 这里不用select prod_price