## 正则搜索(REGEXP关键字 )
### 例子:
~~~sql
SELECT
baby_name
FROM
rainbow.baby
WHERE
baby_name REGEXP '^文(.*)[0-9]$';
~~~
*****
### 例子:查询用户地址表
```sql
SELECT
table_name
FROM
information_schema.`TABLES`
WHERE
table_name REGEXP '^user_address_[0-9]*$';
```