mysql查询语句——进阶

1.查询id=4和id=6的数据(in)

select * form stu where id in(4,6);

2.查询id不等于3也不等于5的数据(not in)

select * from stu where id not in (3,5);

 

3.查询id不等于3的数据(<>)或者（！=）

   select * from stu where id<>3;

4.查询成绩在garde=80到garde=100的学生(between...and...)

 select * from stu where garde between 80 and 100; 

5.查询成绩garde=60到garde=70或者garde=90到garde=100的学生(and的优先级比or高)

SELECT * FROM common_d WHERE COM_ID BETWEEN 60 and 70 OR COM_ID BETWEEN 90 and 100;

6.查询栏目为3和价格小于1000或者大于3000元，并且收藏数大于5(and的优先级比or高，所以加括号）

select * from stu where id=3 and (price < 1000 or price > 3000) and  collect>5;