我使用mysql的GREATEST()函数从任何一列(苹果或桃子)中选择最大的整数值。
+----+------------------+
| id | apples | peaches |
+----+------------------+
| 1 | 8 | 4 |
| 2 | 2 | 6 |
| 3 | 3 | 9 |
| 4 | 7 | 2 |
| 5 | 4 | 4 |
+----+------------------+使用$result = "SELECT GREATEST(apples, peaches) FROM table";和echo $result,我得到:
8
6
9
7在每个值的旁边,我想回显相应的水果名称和一个水果图标。如何通过MYSQL查询实现下图?

另外,请注意GREATEST()函数不会显示相等的值。有没有办法也显示相等的值?
发布于 2010-12-05 08:20:16
SELECT
IF(apples >= peaches, apples, peaches) AS quantity,
IF(apples >= peaches, 'apples', 'peaches') AS fruit
FROM ...或者,如果你不想让苹果作为equal的默认值,并且想知道两个水果什么时候是相等的:
SELECT
IF(apples >= peaches, apples, peaches) AS quantity,
CASE WHEN apples > peaches THEN 'apples' WHEN peaches > apples THEN 'apples' ELSE 'both' END AS fruit
FROM ...https://stackoverflow.com/questions/4356596
复制相似问题