mysql 输入年龄段 通过身份证号获取数据

Question

SELECT *
from customer
where 1=1 and
YEAR (curdate()) -
IF (
length(ID_NUMBER) = 18,
substring(ID_NUMBER, 7, 4),
null
)
IF (
length(ID_NUMBER) = 15,
concat('19',substring(ID_NUMBER, 7, 2)),NULL
)

0

Answer 1

是从身份证号中取出生日？