SELECT * FROM `表名` WHERE timestampdiff(year, substring("360729195908101625",7,8),CURDATE()) > 60;
MYSQL 根据身份证号找出年龄大于60岁的人
最新推荐文章于 2023-07-05 17:08:19 发布
SELECT * FROM `表名` WHERE timestampdiff(year, substring("360729195908101625",7,8),CURDATE()) > 60;