MYSQL 按照身份证筛选年龄和性别

#年龄小于18岁的
 
Select *from (select  id,
substr(CURRENT_DATE,1,4)
-
substr(id_num,7,4)
-
(case SIGN(substr(id_num,11,4)-date_format(CURRENT_DATE,'MMdd')) when -1 then 0 else 1 end) 
AS AGE
,
case mod(substr(id_num,17,1),2) 
when  0 then '女' else '男' end  
AS SEX
from   web_member_real order by AGE asc)t where t.AGE<18
 
 
 
#筛选
select  id,
substr(CURRENT_DATE,1,4)
-
substr(id_num,7,4)
-
(case SIGN(substr(id_num,11,4)-date_format(CURRENT_DATE,'MMdd')) when -1 then 0 else 1 end) 
AS AGE
,
case mod(substr(id_num,17,1),2) 
when  0 then '女' else '男' end  
AS SEX
from   web_member_real order by AGE asc