Mysql-----case when then else end

例子1:

SELECT

`t1`.`id` AS `investid`,
`t1`.`borrowId` AS `borrowId`,
`t1`.`investor` AS `investor`,
`t1`.`investTime` AS `investTime`,
(
CASE `t2`.`isDayThe`
WHEN 2 THEN
0
ELSE
(
CASE (
(`t2`.`paymentMode` * 100) + `t2`.`deadline`
)
WHEN 201 THEN
(`t1`.`investAmount` / 3)
WHEN 202 THEN
((`t1`.`investAmount` * 2) / 3)
WHEN 401 THEN
(`t1`.`investAmount` / 3)
WHEN 402 THEN
((`t1`.`investAmount` * 2) / 3)
ELSE
`t1`.`investAmount`
END
)
END
) AS `facevalue`
FROM
(
`t_invest` `t1`,
`t_borrow` `t2`
)
WHERE
(
(`t1`.`borrowId` = `t2`.`id`)
AND (`t1`.`debtnum` = 0)

)

例子2：

select b.borrowTitle as '借款标题', b.annualRate as '年利率', b.deadline as '借款期限',

CASE WHEN b.isDayThe = 1 THEN '月标' 

WHEN b.isDayThe = 2 THEN '天标' END '是否是天标'
,CASE WHEN b.paymentMode =1 THEN '等额本息'
WHEN b.paymentMode =2 THEN '先息后本' 
WHEN b.paymentMode =4 THEN '一次性还本付息'
WHEN b.paymentMode =5 THEN '等额本金' END '还款方式'
,b.publishTime as '发布时间' from  t_borrow b;