MySQL 黑马课程 16节 条件查询

select id, workno, name, gender, age, idcard, workaddress, entrydate from emp where age = 88;
select id, workno, name, gender, age, idcard, workaddress, entrydate from emp where age < 20;
select id, workno, name, gender, age, idcard, workaddress, entrydate from emp where age <= 20;
select id, workno, name, gender, age, idcard, workaddress, entrydate from emp where idcard is null;
select id, workno, name, gender, age, idcard, workaddress, entrydate from emp where idcard is not null;
select id, workno, name, gender, age, idcard, workaddress, entrydate from emp where age != 80;
select id, workno, name, gender, age, idcard, workaddress, entrydate from emp where age between 15 and 20;
select id, workno, name, gender, age, idcard, workaddress, entrydate from emp where gender = '女' && age < 25;
select id, workno, name, gender, age, idcard, workaddress, entrydate from emp where age = 18 || age = 20 || age = 40;
-- 或
select id, workno, name, gender, age, idcard, workaddress, entrydate from emp where age in(18,20,40);
select id, workno, name, gender, age, idcard, workaddress, entrydate from emp where name like '__';
select id, workno, name, gender, age, idcard, workaddress, entrydate from emp where idcard like '%X' ;