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

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

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

SELECT * FROM abc WHERE idcardnum % 1000000000000 / 100000000 > 1990 && idcardnum % 1000000000000 / 100000000 < 2017;

SELECT concat_ws('/',SUBSTRING(u.id_num , 7 , 4),SUBSTRING(u.id_num , 11 , 2),SUBSTRING(u.id_num , 13 , 2))
FROM user u where u.uid='2'
从身份证号中分离出日期