Mysql查询SQL相关总结（根据生日以及身份证查询年龄以及性别区域等）

1.根据生日查询年龄

SELECT YEAR(CURDATE())-YEAR(birthDate)-(RIGHT(CURDATE(),5)<RIGHT(birthDate,5)) FROM 表名 a WHERE a.`uid` IN(159486);SELECT YEAR(CURDATE())-YEAR(birthDa