mysql计算年龄
标签：
mysql计算年龄
(CURDATE())-YEAR(addtime)-(RIGHT(CURDATE(),5)<RIGHT(addtime,5))
addtime=‘2006-11-2‘
mysql> SELECT id, YEAR(CURDATE())-YEAR(addtime)-(RIGHT(CURDATE(),5)<RIGHT(addtime,5)) FROM user where id=‘109480‘
来自：http://www.cnblogs.com/fenglie/p/3985521.html