条件筛选
where 条件筛选
select * from student_user where age>20;
select * from student_user where age>20 and class=172;
select * from student_user where brithday>'2019-03-28';
select * from student_user where age between 20 and 22;
select * from student_user where age in (20,22);
操作符 |
描述 |
实例 |
= |
等号,检测两个值是否相等,如果相等返回true |
(A = B) 返回false。 |
<>, != |