我希望用mysql正則匹配這樣的字符串：alpha alpha(1) alpha(2)但是不能匹配alpha( 1) alpha(3c)這樣的子串 也就是說括號里必須是數字 并且括號在最后出現也可以不出現我寫了一個但是不大對 麻煩各位大蝦看一下 指正錯誤 ^alpha(\(\d+\))?$mysql版本Ver 14.14 Distrib 5.5.47
1 回答
繁星coding
TA貢獻1797條經驗 獲得超4個贊
mysql> create table alpha(alpha char(20));
Query OK, 0 rows affected (0.20 sec)
mysql> insert into alpha values('alpha'),('alpha(1)'),('alpha(2)'),('alpha( 1)'),('alpha(3c)');
Query OK, 5 rows affected (0.02 sec)
Records: 5 Duplicates: 0 Warnings: 0
mysql> select * from alpha;
+-----------+
| alpha |
+-----------+
| alpha |
| alpha(1) |
| alpha(2) |
| alpha( 1) |
| alpha(3c) |
+-----------+
5 rows in set (0.00 sec)
mysql> select * from alpha where alpha regexp '^alpha(\\([0-9]+\\))?$';
+----------+
| alpha |
+----------+
| alpha |
| alpha(1) |
| alpha(2) |
+----------+
3 rows in set (0.00 sec)
添加回答
舉報
0/150
提交
取消