SQL基础（一二）--- 匹配

单字符匹配：

查询以‘erry’结尾的名称的员工信息：

mysql> select * from t_employee
    -> where fname like '_erry';
+----------+-------+------+---------+
| fnumber  | fname | fage | fsalary |
+----------+-------+------+---------+
| DEV002   | Jerry |   28 | 2300.8  |
| SALES002 | Kerry |   28 | 6200    |
+----------+-------+------+---------+
2 rows in set

查询名称第三个字符是‘n’的并且名称长度为4的员工信息：

mysql> select * from t_employee
    -> where fname like '__n_';
+---------+-------+------+---------+
| fnumber | fname | fage | fsalary |
+---------+-------+------+---------+
| HR001   | Jane  |   23 | 2200.88 |
| HR002   | Tina  |   25 | 5200.36 |
+---------+-------+------+---------+
2 rows in set

多字符匹配：

查询姓名以‘T'开头的员工信息：

mysql> select * from t_employee
    -> where fname like 'T%';
+---------+-------+------+---------+
| fnumber | fname | fage | fsalary |
+---------+-------+------+---------+
| DEV001  | Tom   |   25 | 8300    |
| HR002   | Tina  |   25 | 5200.36 |
+---------+-------+------+---------+
2 rows in set

查询姓名中包含’n'的员工信息：

mysql> select * from t_employee
    -> where fname like '%n%';
+----------+-------+------+---------+
| fnumber  | fname | fage | fsalary |
+----------+-------+------+---------+
| HR001    | Jane  |   23 | 2200.88 |
| HR002    | Tina  |   25 | 5200.36 |
| SALES001 | John  |   23 | 5000    |
| SALES003 | Stone |   22 | 1200    |
+----------+-------+------+---------+
4 rows in set

查询姓名中倒数第二位是‘n’，长度任意的员工信息：

mysql> select * from t_employee
    -> where fname like '%n_';
+----------+-------+------+---------+
| fnumber  | fname | fage | fsalary |
+----------+-------+------+---------+
| HR001    | Jane  |   23 | 2200.88 |
| HR002    | Tina  |   25 | 5200.36 |
| SALES003 | Stone |   22 | 1200    |
+----------+-------+------+---------+
3 rows in set