mysql中正则表达式中的分组查询一个简单问题（待解决）

最新推荐文章于 2024-07-28 03:29:16 发布

发狂的蜗牛

最新推荐文章于 2024-07-28 03:29:16 发布

阅读量384

点赞数

CC 4.0 BY-SA版权

分类专栏： ubuntu linux

本文链接：https://blog.youkuaiyun.com/digitalkee/article/details/117667703

linux 同时被 2 个专栏收录

100 篇文章

订阅专栏

ubuntu

43 篇文章

订阅专栏

本文通过示例分析了MySQL中的正则表达式查询，展示了在使用`(o|e){2}

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

mysql> select * from t2;
+------+------+-------------+------+-------------+
| id   | name | address     | yy1  | favourater  |
+------+------+-------------+------+-------------+
|   11 |    1 | zhongshna1  |    2 | computer    |
|   12 |    1 | zhongshna1  |    2 | computer    |
|   13 |    1 | zhongshna1  |    2 | computer    |
|   14 |    2 | fengzhenshi |    3 | mathematics |
|   15 |    3 | bookkeeper  |    3 | mathematics |
|   16 |    3 | bookkeepers |    5 | mathematics |
|   16 |    3 | boekkeepers |    5 | mathematics |
|   17 |    3 | boekkoepers |    5 | mathematics |
+------+------+-------------+------+-------------+
8 rows in set (0.00 sec)

mysql> select address from t2 where  address regexp '(o|e){2}.*e{2}';
+-------------+
| address     |
+-------------+
| bookkeeper  |
| bookkeepers |
| boekkeepers |
+-------------+
3 rows in set (0.00 sec)

为啥结果会出现 boekkeepers?

查询条件 (o|e){2}.*e{2} 中o和e已经被 | 隔开，那么应该出现2个o 或者2个e然后后面接着2个e才对,但是第三个条件并不满足呀？

看下面这句，还是同样的问题。

mysql> select address from t2 where  address regexp '(o|e){2}.*ee';
+-------------+
| address     |
+-------------+
| bookkeeper  |
| bookkeepers |
| boekkeepers |
+-------------+