datediff并不好用,原谅我不会用。
查找距今超过10年的年份数据
mysql> select * from mydate where timestampdiff(year,bir,now())>10;
附:
年份区间内:
mysql> select * from mydate where bir between '1900-1-1' and '1999-12-31';
datediff并不好用,原谅我不会用。
查找距今超过10年的年份数据
mysql> select * from mydate where timestampdiff(year,bir,now())>10;
附:
年份区间内:
mysql> select * from mydate where bir between '1900-1-1' and '1999-12-31';