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 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