Mysql基础第十天,数据过滤

1.组合WHERE子句

select prod_name,vend_id,prod_price from products where vend_id=1003 and prod_price=2.5;  // 使用and
  select prod_name,vend_id,prod_price from products where vend_id=1010 or prod_price>=10;  // 使用or
  select prod_name,vend_id,prod_price from products where vend_id=1002 and vend_id=1003 or prod_price>=10; // 使用and和or

2.in操作符

select vend_name,vend_city from vendors where vend_city in ('New York','Lundon','paris');  // in 查询

3. NOT 操作符

select vend_name,vend_city from vendors where vend_city not in ('New York','Lundon','paris');  // not 查询

4.小结

感谢观看