MySQL 排序列表问题

Question

我有以下代码:

SELECT    q21coding, COUNT(q21coding) AS Count 
FROM      `tresults_acme` 
WHERE     q21 IS NOT NULL AND q21 <> '' 
GROUP BY  q21coding 
ORDER BY  Count DESC

它返回以下内容:

q21coding                                  Count 
Difficulty in navigating/finding content     53
Positive comments                            28
Suggestions for improvement                  14
Inappropriate content/use                    13
Improve search facility                       6
Include information about staff and teams     5
Content needs updating                        4
Other                                        30

您会注意到“其他”是倒数第二个 - 有没有办法确保“其他”始终位于底部，无论计数大小如何？

谢谢

荷马

Answer 1

ORDER BY IF(q21coding = 'Other', 1, 0) ASC, Count DESC