LIKE操作符

　　作用：用于在WHERE子句中搜索列中的指定模式。

　　语法：SELECT  COLUMN_NAME  FROM  TABLE_NAME  WHERE  COLUMN_NAME  LIKE  PATTERN;

现在我们创建一个表

mysql> SELECT * FROM information;+------+----------+-----------------+-----------+| id   | name     | address         | city      |+------+----------+-----------------+-----------+| 1001 | xiaoming | NiuJin          | England   || 1002 | xiaochen | Oxford street   | New York  || 1003 | xiaoming | chaoyang street | Beijing   || 1004 | xiaohua  | haha street     | Zhengzhou |+------+----------+-----------------+-----------+4 rows in set (0.00 sec)

1、找出以“E”开头的城市的个人信息

mysql> SELECT * FROM information WHERE city LIKE 'E%';+------+----------+---------+---------+| id   | name     | address | city    |+------+----------+---------+---------+| 1001 | xiaoming | NiuJin  | England |+------+----------+---------+---------+1 row in set (0.00 sec)

2、找出包含“ch”子串的姓名的个人信息

mysql> SELECT * FROM information WHERE name LIKE '%ch%';+------+----------+---------------+----------+| id   | name     | address       | city     |+------+----------+---------------+----------+| 1002 | xiaochen | Oxford street | New York |+------+----------+---------------+----------+1 row in set (0.00 sec)

3、找出不包含“ch”子串的姓名的个人信息

mysql> SELECT * FROM information WHERE name NOT LIKE '%ch%';+------+----------+-----------------+-----------+| id   | name     | address         | city      |+------+----------+-----------------+-----------+| 1001 | xiaoming | NiuJin          | England   || 1003 | xiaoming | chaoyang street | Beijing   || 1004 | xiaohua  | haha street     | Zhengzhou |+------+----------+-----------------+-----------+3 rows in set (0.00 sec)