MySQL在AND，OR子句和查询问题之间进行选择，查询

“群”是什么意思？

如果要使用GROUP BY，可以执行以下操作：

SELECt    CASE        WHEN pre BETWEEN 5300 AND 5310 OR pre BETWEEN 7100 AND 7200 OR pre BETWEEN 8210 AND 8290        THEN 'Group A'        ELSE 'Group B'    END AS grp,    COUNT(*) AS cntFROM your_tableGROUP BY grp

也许您只是想订购？

SELECt    CASE        WHEN pre BETWEEN 5300 AND 5310 OR pre BETWEEN 7100 AND 7200 OR pre BETWEEN 8210 AND 8290        THEN 'Group A'        ELSE 'Group B'    END AS grp,    *FROM your_tableORDER BY grp

还要注意BETWEEN包括两个端点，这可能不是您的意思。