条件查询
elect … from 表名 where …
比较运算符
>
- 查询大于18岁的信息
select * from students where age>18;
select id,name,gender from students where age>18;
<
- 查询小于18岁的信息
select * from students where age<18;
>= <=
- 查询小于或等于18岁的信息
=
- 查询年龄为18岁的所有学生的名字
select * from students where age=18;
!= 或者 <>
逻辑运算符
and
-
18到28岁之间所有学生的信息
select * from students where age>18 and age<28;
失败select * from students where age>18 and <28; -
18岁以上的女性
select * from students where age>18 and gender=“女”;
select * from students where age>18 and gender=2;