# 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)
```