10.笔记 MySQL学习——模式匹配
模式匹配需要使用像LIKE和NOT LIKE运算符。
下划线_ 可以匹配任何单个字符,百分号 % 匹配任何字符序列。
mysql>select last_name,first_name from president where last_name like 'W%';
+------------+------------+
| last_name | first_name |
+------------+------------+
| Washington | George |
| Wilson | Woodrow |
+------------+------------+
2 rows in set (0.00 sec)
mysql> select last_name,first_name from presidentwhere last_name like '______';
+-----------+------------+
| last_name | first_name |
+-----------+------------+
| Monroe | James |
| Taylor | Zachary |
| Pierce | Franklin |
| Arthur | Chester A. |
| Wilson | Woodrow |
| Hoover | Herbert C. |
| Truman | Harry S |
| Carter | James E. |
| Reagan | Ronald W. |
+-----------+------------+
9 rows in set (0.00 sec)