MySQL-DQL-条件查询

ZRSAI

于 2023-05-25 15:26:29 发布

阅读量80

点赞数

CC 4.0 BY-SA版权

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

本文链接：https://blog.youkuaiyun.com/ZRSAI/article/details/130867731

MySQL 专栏收录该内容

12 篇文章

订阅专栏

文章展示了多个SQL查询语句，用于从emp表中筛选员工数据，条件包括年龄等于、不等于、小于、小于等于、大于、大于等于某个值，ID卡是否为空，以及性别、年龄在特定范围内的组合查询。还包含了使用LIKE操作符进行模糊匹配的例子。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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";