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