MySQL高级数据过滤

数据表格，创造数据都在上篇文章MySQL常用语句里，可以在我的栏目里看到。

这篇写MySQL高级数据过滤

查询供应商为DLL01且制造价钱小于等于4美元的所有产品的价格和名称

select prod_id,prod_price,prod_name from products where vend_id = "DLL01" AND prod_price <=4;

查询供应商为DLL01或制造价钱小于等于6美元的所有产品的价格和名称

select prod_id,prod_price,prod_name,vend_id from products where vend_id = "DLL01" or prod_price <=6;

查询供应商为DLL01或供应商为BRS01且制造价钱小于等于6美元的所有产品的价格和名称

select prod_id,prod_price,prod_name,vend_id from products where (vend_id = "DLL01" or vend_id = "BRS01") and prod_price <=6;

查询生产为"DLL01" , "BRS01"生产的产品

select prod_id,prod_price,prod_name,vend_id from products where vend_id in ( "DLL01" , "BRS01") order by prod_name;

查询生产为不是"DLL01" 生产的产品

select prod_id,prod_price,prod_name,vend_id from products where NOT vend_id ="DLL01" order by prod_name;