mysql - 如何在查询中只乘以一行？

Question

SELECT user_id, currency, SUM( price ) AS totalPrice, created
FROM accounts WHERE user_id IN ( SELECT users.id FROM users
                                 WHERE country_id ='$con_id' )
AND created BETWEEN  '2013-02-01' AND  '2013-02-28' GROUP BY currency

这个查询给我这样的结果

Curreny  totalPrice
SEK      10
USD      10

我只想将 7 乘以 SEK。我在数据库中只有 USD 汇率，所以我想在查询中将它乘以 7 以获得 SEK 汇率。我如何在此查询中执行此操作？

Answer 1

您的问题有点令人困惑。如果我正确理解您的问题，如果货币等于 SEK，您希望将 total value 的值乘以 7。

SELECT  user_id, 
        currency, 
        SUM(price) * IF(currency = 'SEK', 7, 1) totalPrice, 
        created
FROM    accounts
WHERE   user_id
        IN 
        (
            SELECT users.id
            FROM users
            WHERE country_id =  '$con_id'
        ) AND 
        created BETWEEN  '2013-02-01' AND  '2013-02-28'
GROUP   BY currency