sql根据身份证号算年龄

select (year(NOW())- substring(ages,7,4)) age from `user`