MySql 中sql IF写法

例子：

 

SELECT
  di.name AS '交易名',
  mi.companyname AS '商家名',
  ( IF(di.typeof=0,'普通发货',( IF(di.typeof=1,'密码券','优惠券') ) ) ) AS '交易类型',
  TIMESTAMP(FROM_UNIXTIME(di.begintime/1000)) AS '交易开始时间',
  TIMESTAMP(FROM_UNIXTIME(di.endtime/1000)) AS '交易结束时间',
  di.sold AS '实际成交数',
  di.price AS '交易单价',
  di.sold * di.price AS '成交总额',
  md.purchase AS '交易成本',
  di.discount AS '折扣'
FROM
  merchant_info mi,
  deals_info di
  LEFT JOIN merchant_deal md
    ON md.merchantid = di.merchantid
      AND md.modifytime = di.createtime
WHERE di.citycode = '0731'
    AND style=1
    AND mi.uid=di.merchantid
    AND di.begintime > UNIX_TIMESTAMP('2011-03-23 00:00:00') * 1000 ORDER BY di.begintime