SQL基础（一五）--- 多值检测

查询年龄是23、25、28的员工信息：

方式一

mysql> select * from t_employee
    -> where fage=23 or fage=25 or fage=28;
+----------+-------+------+---------+
| fnumber  | fname | fage | fsalary |
+----------+-------+------+---------+
| DEV001   | Tom   |   25 | 8300    |
| DEV002   | Jerry |   28 | 2300.8  |
| HR001    | Jane  |   23 | 2200.88 |
| HR002    | Tina  |   25 | 5200.36 |
| IT001    | Smith |   28 | 3900    |
| SALES001 | John  |   23 | 5000    |
| SALES002 | Kerry |   28 | 6200    |
+----------+-------+------+---------+
7 rows in set

方式二

mysql> select * from t_employee
    -> where fage in(23,25,28);
+----------+-------+------+---------+
| fnumber  | fname | fage | fsalary |
+----------+-------+------+---------+
| DEV001   | Tom   |   25 | 8300    |
| DEV002   | Jerry |   28 | 2300.8  |
| HR001    | Jane  |   23 | 2200.88 |
| HR002    | Tina  |   25 | 5200.36 |
| IT001    | Smith |   28 | 3900    |
| SALES001 | John  |   23 | 5000    |
| SALES002 | Kerry |   28 | 6200    |
+----------+-------+------+---------+
7 rows in set