MySQL-DQL-条件查询

最新推荐文章于 2024-10-20 17:13:34 发布

ZRSAI

最新推荐文章于 2024-10-20 17:13:34 发布

阅读量66

点赞数

分类专栏： MySQL 文章标签： mysql 数据库 sql

本文链接：https://blog.csdn.net/ZRSAI/article/details/130867731

版权

MySQL 专栏收录该内容

12 篇文章 0 订阅

订阅专栏

select * from emp where age = 88;
select * from emp where age < 20;
select * from emp where age <= 20;
select * from emp where idcard is null;
select * from emp where idcard is not null;
select * from emp where age <> 88;
select * from emp where age != 88;
select * from emp where age >= 15 and age <= 20;
select * from emp where age between 15 and 20;
select * from emp where gender = "女" and age < 25;
select * from emp where age = 18 or age = 20 or age = 40;
select * from emp where age in (18,20,40);
select * from emp where name like "__";
select * from emp where idcard like "%X";