Mysql 在查询中多次之间

Mysql multiple times between in query

本文关键字：之间查询 Mysql | 更新日期: 2023-09-27

我需要显示年龄结果差异，例如年龄在 5 至 10 岁之间，年龄在 50 至 55 岁之间

$sql = "select name,age from tbl where (age BETWEEN 5 AND 10) OR (age BETWEEN 50 AND 55)";
$res = mysql_query($sql)

select name,age, case when age BETWEEN 5 AND 10
                      then '5-10'
                      else '50-55'
                end as age_between
from tbl 
where ( age BETWEEN 5 AND 10)  
or (age BETWEEN 50 AND 55)

顺便说一句，最好存储出生日期。然后，您不必设置年龄。