SELECT
(CASE
WHEN CAST(age AS SIGNED) >= 18 and CAST(age AS SIGNED) <= 29 THEN
'18-29岁'
WHEN CAST(age AS SIGNED) >= 30 and CAST(age AS SIGNED) <= 39 THEN
'30-39岁'
WHEN CAST(age AS SIGNED) >= 40 and CAST(age AS SIGNED) <= 49 THEN
'40-49岁'
ELSE
'-1'
END) as '年龄段',
id,`name`,gender,age
FROM user;
年龄段 | id | name | age |
---|---|---|---|
30-39岁 | 1 | 张三 | 30 |
-1 | 2 | 张三 | 0 |
18-29岁 | 3 | 张三 | 23 |