Some values in the ID number field in the table are invalid. How can I check the valid information for the ID number? Thanks
Regular expression:
ID card regex: d{6}(18|19|20)d{2}(0[1-9]|1[120])(0[1-9]|[12]d|3[01])d{3}(d|X) Mysql regex:
d{6}(18|19|20)d{2}(0[1-9]|1[120])(0[1-9]|[12]d|3[01])d{3}(d|X)
select * from table where identity regexp '[[:digit:]]{6}(18|19|20)[[:digit:]]{2}(0[1-9]|1[120])(0[1-9]|[12][[:digit:]]|3[01])[[:digit:]]{3}([[:digit:]]|X)'
select * from 表 where list regexp '^[0-9]{18}$'
list
Regular expression:
ID card regex:
d{6}(18|19|20)d{2}(0[1-9]|1[120])(0[1-9]|[12]d|3[01])d{3}(d|X)
Mysql regex:
select * from 表 where
list
regexp '^[0-9]{18}$'