mysql之查询常用关键字二

mysql之查询常用关键字二

BETWEEN

包含边界

select * from m_blog where user_id between 3 and 5;

NOT BETWEEN

select * from m_blog where user_id not between 3 and 5;

IN

select * from m_blog where user_id in (2,3,4);

NOT IN

select * from m_blog where user_id not in (2,3,4);

IS NULL

我们修改一下数据库，将status设置为null,将description的一条记录设置为空

select * from m_blog where m_blog.status is null;

select * from m_blog where m_blog.description is null;

证明 一个问题，空不等于null

IS NOT NULL

select * from m_blog where m_blog.status is not null;