# Regular Expression Compound Pattern Example
__*RLIKE operation*__
__*REGEXP operation*__
__*regular expression*__
+ `Los|Las, L[oa]s`: Expression Equivalent 
+ For example: `^[A-HJ-NP-Z][0-9]{4}([A-Z]{3})?$`  
  + First character pattern: `[A-HJ-NP-Z]`  
  + The second to fifth characters pattern: `[0-9]`  
  + It is followed by three characters pattern: `[A-Z]{3}`  
    + Or maybe none of the above pattern: `()?`  
+ `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)
```