mysql 按时间查询的问题

[natato]

页面上给的是岁数，数据库中写的是生日，我要查15到35岁的之间数据怎么查呀谢了
用的是mysql，
表 user
id name sex birthday
1 s a 1978-1-6
2 d a 1976-5-5

[liangCK]

SELECT *
FROM tb
WHERE DATEDIFF(YEAR,birthday,GETDATE()) BETWEEN 15 AND 35

[pt1314917]

SELECT *
FROM tb WHERE DATEDIFF(yy,birthday,GETDATE()) BETWEEN 15 AND 35

[lgxyz]

数据量不多就 直接加DATEDIFF操作

WHERE DATEDIFF(yy,birthday,GETDATE()) BETWEEN 15 AND 35

如果数据量相当多就
换个写法

WHERE birthday >= DATENAME(YEAR,DATEADD(YEAR,-35,GETDATE()))+'-01-01'
      AND birthday <= DATENAME(YEAR,DATEADD(YEAR,-15,GETDATE()))+'-12-31'

[liuyilidan]

SELECT * FROM [user] WHERE DATEDIFF(YEAR,birthday,GETDATE()) BETWEEN 15 AND 35

[分治实践]

SELECT * FROM tb WHERE year(now())-year(birthday) BEGIN 15 AND 35

他要的是MySqL的写法

[分治实践]

Mysql里面没有直接比较年的函数.
所以只能用year(now())减去year(birthday)得到年龄