13、MySQL的正则表达式

最新推荐文章于 2023-11-09 19:28:40 发布

原创

最新推荐文章于 2023-11-09 19:28:40 发布 · 98 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql

本文介绍了MySQL中正则表达式的使用，包括基本字符串匹配、or条件、范围搜索、排它符、特殊字符匹配、问号通配以及字符类的应用。

1、基本字符串匹配 regexp

mysql> select * from products where prod_name regexp '1000';
+---------+---------+--------------+------------+---------------------------------------+
| prod_id | vend_id | prod_name    | prod_price | prod_desc                             |
+---------+---------+--------------+------------+---------------------------------------+
| JP1000  |    1005 | JetPack 1000 | 35.00      | JetPack 1000, intended for single use |
+---------+---------+--------------+------------+---------------------------------------+
1 row in set (0.08 sec)

.号代表任意一个字符要加\转义符号变成原来的.

mysql> select * from products where prod_name regexp '.000';
+---------+---------+--------------+------------+---------------------------------------+
| prod_id | vend_id | prod_name    | prod_price | prod_desc                             |
+---------+---------+--------------+------------+---------------------------------------+
| JP1000  |    1005 | JetPack 1000 | 35.00      | JetPack 1000, intended for single use |
| JP2000  |    1005 | JetPack 2000 | 55.00      | JetPack 2000, multi-use               |