Combining MySQL aggregate functions with MySQL IF() function can be very helpful to get the specific output we want. Consider the following queries which combine SUM() and COUNT() aggregate functions with IF() function.
Example
mysql> Select SUM(IF(Language = 'English', 1, 0)) As English, SUM(IF(Language <> 'English',1,0)) AS "Non-English" from Students; +---------+-------------+ | English | Non-English | +---------+-------------+ | 5 | 4 | +---------+-------------+ 1 row in set (0.00 sec)
上述查询将SUM()聚合函数与IF()函数结合使用，从“学生”表中获取英语母语学生和非英语母语学生的输出。
动态WEB网站中的PHP和MySQL：直观的QuickPro指南第2版
下载
动态WEB网站中的PHP和MySQL详细反映实际程序的需求，仔细地探讨外部数据的验证(例如信用卡卡号的格式)、用户登录以及如何使用模板建立网页的标准外观。动态WEB网站中的PHP和MySQL的内容不仅仅是这些。书中还提到如何串联JavaScript与PHP让用户操作时更快、更方便。还有正确处理用户输入错误的方法，让网站看起来更专业。另外还引入大量来自PEAR外挂函数库的强大功能，对常用的、强大的包
mysql> Select COUNT(IF(country = 'USA', 1, NULL))AS USA,
-> COUNT(IF(country = 'UK', 1, NULL))AS UK,
-> COUNT(IF(country = 'France', 1, NULL))AS France,
-> COUNT(IF(country = 'Russia', 1, NULL))AS Russia,
-> COUNT(IF(country = 'Australia', 1, NULL))AS Australia,
-> COUNT(IF(country = 'INDIA', 1, NULL))AS INDIA,
-> COUNT(IF(country = 'NZ', 1, NULL))AS NZ FROM Students;
+-----+----+--------+--------+-----------+-------+----+
| USA | UK | France | Russia | Australia | INDIA | NZ |
+-----+----+--------+--------+-----------+-------+----+
| 2 | 1 | 1 | 1 | 1 | 2 | 1 |
+-----+----+--------+--------+-----------+-------+----+
1 row in set (0.07 sec)上面的查询将COUNT()聚合函数与IF()函数结合起来，以从“Students”表中获取国家数量的输出。
