# LIKE 的转义字符
__*LIKE operation*__

+ 默认转义字符: `\`
+ 改变转义字符: `... LIKE '<pattern>' ESCAPE '<escape_character>'`
+ 例如，我们需要模糊匹配从 90% 到 99%:
  + `... LIKE '9_\%'`

+ 观察下例，问题在哪里?
```8
tidb> SELECT '95%' WHERE '95%' like '9_%';
+-----+
| 95% |
+-----+
| 95% |
+-----+
1 row in set (0.00 sec)

tidb> SELECT '955' WHERE '955' like '9_%';
+-----+
| 955 |
+-----+
| 955 |
+-----+
1 row in set (0.00 sec)
```

------------------------------------------------------------
In this example, we don't expect '955' as the correct result.

The correct LIKE clause can be:

```
tidb> select '95%' WHERE '95%' like '9_\%';
+-----+
| 95% |
+-----+
| 95% |
+-----+
1 row in set (0.00 sec)

tidb> select '955' WHERE '955' like '9_\%';
Empty set (0.00 sec)

```

Or:

```
tidb> select '95%' WHERE '95%' like '9_#%' ESCAPE '#';
+-----+
| 95% |
+-----+
| 95% |
+-----+
1 row in set (0.00 sec)

tidb> select '955' WHERE '955' like '9_#%' ESCAPE '#';
Empty set (0.00 sec)

```