select * from test_table where (name regexp ‘Z([0-9]{6})’) = 1
查询test_table表中name字段是Z+6位数字的记录
由若干个字母、数字、下划线和中划线组成:
[a-zA-Z0-9_-]+
正则表达式:https://blog.csdn.net/sinat_34626741/article/details/123883244
select * from test_table where (name regexp ‘Z([0-9]{6})’) = 1
查询test_table表中name字段是Z+6位数字的记录
由若干个字母、数字、下划线和中划线组成:
[a-zA-Z0-9_-]+
正则表达式:https://blog.csdn.net/sinat_34626741/article/details/123883244