MySQL-DQL-条件查询

最新推荐文章于 2025-12-15 13:56:53 发布

原创最新推荐文章于 2025-12-15 13:56:53 发布 · 92 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql #数据库 #sql

MySQL 专栏收录该内容

12 篇文章

订阅专栏

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

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