Question

First I 查询,问这样做,并接受回答。但现在的问题是,我不得不在几个月内计算年龄。

Question:

I have a BirthDate column in MySQL database table to store user s date of birth. Now I have form in html/php with two fields(1. Age From 2. Age To).

如果使用者想要让所有年龄在400个月到600个月的用户都参与进来,则有可能使用出生分类栏与MySQL查询。

增编

Answer 1


select * from [table] 
where 
BirthDate&gt= date_sub(curdate(),interval 600 MONTH)
and 
BirthDate&lt= date_sub(curdate(),interval 400 MONTH)

Answer 2

SELECT * FROM that_table
WHERE CURRENT_TIMESTAMP BETWEEN (BirthDate + INTERVAL 400 MONTH) AND (BirthDate + INTERVAL 600 MONTH)