mysql order by count -按值排序

Question

我正在尝试通过分组来计算数据库中的记录数。这可以很好地工作，但当我尝试按排序时，它会用一种不同于所需的方法对计数进行排序。示例结果：

Question - Answer - Count

Q1 - A1 - 1

Q2 - A2 - 11

Q3 - A3 - 2

想要的结果:我想要2-9之后的11，而不是之前。查询很简单：

SELECT Question, Answer, count(*) as `Count` GROUP BY Question, Answer ORDER BY Question, Answer

这种排序的另一个示例是mysql排序，如1,11,118,12,2,3，其中我期望的是递增的值，如1,2,3,11,12,118

Answer 1

尝试此查询

SELECT Question, Answer, count(*) as `Count`
FROM table
GROUP BY Question, Answer
ORDER BY count(*) ASC

Answer 2

您在查询中输入了

ORDER BY Question, Answer

如果您希望11紧跟在2之后，那么您肯定希望

ORDER BY Count

Answer 3

问题似乎是我试图按字符值而不是整数值排序？我必须将答案转换为整数，然后它才能正确排序。下面是一个有效的查询：

SELECT Question, Answer, count(*) as `Count` GROUP BY Question, Answer ORDER BY Question, CAST( answer AS SIGNED INTEGER )

在这里找到了答案：Sorting varchar field numerically in MySQL