13、MySQL的正则表达式_mysql金额正则表达式-优快云博客

本文链接：https://blog.youkuaiyun.com/dingpython/article/details/113052613

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

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

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               |
+