YEAR(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
原文：http://www.cnblogs.com/dengyg200891/p/5966086.html