mysql 字符类以及重复元字符

 

字符类

[:alnum:]=[a-zA-Z0-9]

[:alpha:]=[a-zA-Z]

[:digit:]=[0-9]

[:lower:]=[a-z]

[:upper:]=[A-Z]

[:xdigit:]=[a-fA-F0-9]



重复元字符

* = >=0
+ = >=1 = {1,}
? = {0,1}

{n} 指定数目
{n,} = >=n
{n,m} = >=n and <=m