SELECT birthday age, COUNT(*)VALUE FROM t_member WHERE TIMESTAMPDIFF(YEAR,birthday,NOW()) BETWEEN 0 AND 18
SELECT birthday age, COUNT(*)VALUE FROM t_member WHERE TIMESTAMPDIFF(YEAR,birthday,NOW()) BETWEEN 19 AND 30
SELECT birthday age, COUNT(*)VALUE FROM t_member WHERE TIMESTAMPDIFF(YEAR,birthday,NOW()) BETWEEN 31 AND 45
SELECT birthday age, COUNT(*)VALUE FROM t_member WHERE TIMESTAMPDIFF(YEAR,birthday,NOW())>45
between and 是包含边界的,从这些语句的条件来看,最终的返回其实就是 TIMESTAMPDIFF(YEAR,birthday,NOW()) 取值区间是 [0,正无穷),统一为一条SQL 条件为
WHERE TIMESTAMPDIFF(YEAR,birthday,NOW())>=0