MySQL如何将WHERE子句中未指定的值分组为 "others"？

Question

我需要制作一份网站访问统计报告。在报告中用户可以指定各种参数。到目前为止，每当他们为参数选择值时，就会添加一个附加的 WHERE 子句，如下所示:

SELECT id_browser, COUNT(visits)
FROM table
WHERE [...] 
AND id_browser IN (1, 3, 6)
GROUP BY id_browser

但我真正需要做的是显示其余浏览器的统计信息，但我需要将它们分组为“其他浏览器”。我怎样才能做到这一点？

Answer 1

尝试以下:

    SELECT id_browser, 
    count(if(id_browser IN (1, 3, 6),1,0)) as 136browser,
    count(if(id_browser Not IN (1, 3, 6),1,0)) as other_browser
    FROM table
    WHERE [...] 
    GROUP BY id_browser