MySQL条件查询语句有哪些？

==， !=, <>（不等于）, <, >, <= >, >=
BETWEEN ... AND
IN(set) : 几个固定值
IS NULL , IS NOT NULL
AND
OR
NOT： 非

SELECT * FROM stu WHERE sid = "s_1001" OR sname="lisi";

SELECT * FROM stu WHERE sid IN("s_1001", "s_1002", "s_1003");  // 查询符合条件的集合中
+--------+----------+------+--------+
| sid    | sname    | age  | gender |
+--------+----------+------+--------+
| s_1001 | liuYing  |   35 | male   |
| s_1002 | chenger  |   20 | male   |
| s_1003 | zhangsan |   15 | female |
+--------+----------+------+--------+

SELECT * FROM stu WHERE sid NOT IN("s_1001", "s_1002", "s_1003");  // 查询符合条件不在集合中

+--------+----------+------+--------+
| sid    | sname    | age  | gender |
+--------+----------+------+--------+
| s_1004 | wangwu   |   23 | male   |
| s_1005 | liuYin   |   35 | female |
| s_1006 | zhaoliu  |   70 | male   |
| s_1007 | sunQi    |   15 | female |
| s_1008 | zhouBa   |   43 | male   |
| s_1009 | wuJiu    |   85 | female |
| s_1010 | zhengShi |    5 | male   |
+--------+----------+------+--------+

 SELECT * FROM stu WHERE age IS NULL;

 SELECT * FROM stu WHERE age IS NOT NULL;

  SELECT * FROM stu WHERE age BETWEEN 20 AND 40;
  SELECT * FROM stu WHERE age >= 20 AND age <= 40;

+--------+---------+------+--------+
| sid    | sname   | age  | gender |
+--------+---------+------+--------+
| s_1001 | liuYing |   35 | male   |
| s_1002 | chenger |   20 | male   |
| s_1004 | wangwu  |   23 | male   |
| s_1005 | liuYin  |   35 | female |
+--------+---------+------+--------+