MySQL查询篇-where子句

where常见的condition

=
!=
>
<
>=
<=
and 
or 

between and

分为数值类型和日期时间类型的判定

1.数值类型 -> 左闭右闭区间

select * from talbe where num between 1 and 5;
-- >=1 且 <=5的数据

2.日期时间类型 -> 也是左闭右闭区间 但未指定时间时默认为 00:00:00

select * from table where date between '2024-01-02' and '2041-01-02';
-- 指的是 '2024-01-02 00:00:00' 到 '2041-01-02 00:00:00'的数据
-- 2024-01-02 13:00:00 在区间内  2041-01-02 13:00:00 不在区间内

in 和 not in

select * from table where sn in ('1','2','3');
select * from table where sn not in ('1','2','3');
-- sn值为1或者2或者3的数据

is null 和 is not null

select * from table where sn is null;
select * from table where sn is not null;

select * from table where sn is not null;