mysql - 正则表达式 MySQL，查找至少包含 2 个字母和 2 个数字的字符串

Question

我正在使用这个正则表达式 REGEXP '^([a-z]){2,}([0-9]){2,}$'结合此 REGEXP '^([0-9]){2,}([a-z]){2,}$' 查找包含超过 2 个字母和超过 2 个数字的字符串。这仅涵盖以数字开头或以数字结尾的字符串。

我还需要一个正则表达式来查找字母之间的数字。

MySQL 版本 5.1.73

Answer 1

这是最长的:

^[[:alpha:]]{2,}[[:digit:]]{2,}$|^[[:alpha:]]{1,}[[:digit:]]{1,}[[:alpha:]]{1,}[[:digit:]]{1,}$|^[[:digit:]]{1,}[[:alpha:]]{1,}[[:digit:]]{1,}[[:alpha:]]{1,}$|^[[:alpha:]]{1,}[[:digit:]]{2,}[[:alpha:]]{1,}$|^[[:digit:]]{1,}[[:alpha:]]{2,}[[:digit:]]{1,}$|^[[:digit:]]{2,}[[:alpha:]]{2,}$

mysql> select * from testtable;
+-------------+
| testcol     |
+-------------+
| 11aaa       |
| dd12        |
| s1s2        |
| 32423sdfsfd |
| sdfs12313   |
| saf234sfs   |
| asdf3sdf    |
+-------------+
7 rows in set (0.00 sec)

mysql> select * from testtable where testcol regexp '^[[:alpha:]]{2,}[[:digit:]]{2,}$|^[[:alpha:]]{1,}[[:digit:]]{1,}[[:alpha:]]{1,}[[:digit:]]{1,}$|^[[:digit:]]{1,}[[:alpha:]]{1,}[[:digit:]]{1,}[[:alpha:]]{1,}$|^[[:alpha:]]{1,}[[:digit:]]{2,}[[:alpha:]]{1,}$|^[[:digit:]]{1,}[[:alpha:]]{2,}[[:digit:]]{1,}$|^[[:digit:]]{2,}[[:alpha:]]{2,}$';
+-------------+
| testcol     |
+-------------+
| 11aaa       |
| dd12        |
| s1s2        |
| 32423sdfsfd |
| sdfs12313   |
| saf234sfs   |
+-------------+
6 rows in set (0.00 sec)