SELECT CASE WHEN(memberAge<18) THEN '少年' WHEN(memberAge>=18 and memberAge <30) THEN '青年' WHEN(memberAge>=30 and memberAge<50) THEN '中年' ELSE '老年' END AS ageMeno,sk.* FROM `sk_member` sk;
转载于:https://www.cnblogs.com/LCYXX/p/10002642.html
SELECT CASE WHEN(memberAge<18) THEN '少年' WHEN(memberAge>=18 and memberAge <30) THEN '青年' WHEN(memberAge>=30 and memberAge<50) THEN '中年' ELSE '老年' END AS ageMeno,sk.* FROM `sk_member` sk;
转载于:https://www.cnblogs.com/LCYXX/p/10002642.html