# 正则表达式复合模式示例

__*RLIKE 操作*__
__*REGEXP 操作*__
__*正则表达式*__

+ `Los|Las, L[oa]s`: 表达式等价 
+ 例如: `^[A-HJ-NP-Z][0-9]{4}([A-Z]{3})?$` 
  + 第一个字符: `[A-HJ-NP-Z]` 
  + 第二个到第五个字符可以是: `[0-9]` 
  + 后跟三个字符: `[A-Z]{3}` 
    + 或者可能没有以上模式: `()?` 
+ `SELECT name, mass FROM universe.planets WHERE name RLIKE '(Ura|Ve)nus';` 
+ `SELECT * FROM addresses WHERE postcode RLIKE '^[A-HJ-NP-Z][0-9]{4}([A-Z]{3})?$';` 

```
tidb> SELECT name, mass FROM universe.planets WHERE name RLIKE '~!@(Ura|Ve)nus@!~';
+--------+------+
| name   | mass |
+--------+------+
| Venus  | 4.87 |
| Uranus | 86.8 |
+--------+------+
2 rows in set (0.00 sec)
```
-------------------------------------------------------------------------------------
```
tidb> SELECT name, mass FROM universe.planets WHERE name RLIKE '(Ura|Ve)nus';
+--------+------+
| name   | mass |
+--------+------+
| Venus  | 4.87 |
| Uranus | 86.8 |
+--------+------+
2 rows in set (0.00 sec)
```