1.这个函数有两种结构:
(1)CASE [value] WHEN [compare-value] THEN [result] {WHEN [compare-value] THEN [result] WHEN [compare-value] THEN [result]...}ELSE [result] END;
eg:CASE X WHEN '01' THEN '股权产品' WHEN '02' THEN '固定产品' WHEN '03' THEN '浮动产品' ELSE ‘没有此类产品’ END;
CASE WHEN [value]=[compare-value] THEN [result] {WHEN [value]=[compare-value] THEN [result] WHEN [value]=[compare-value] THEN [result]...} ELSE [result] END;
eg:CASE WHEN X='01' THEN '股权产品' WHEN X='02' THEN '固定产品' WHEN X='03' THEN '浮动产品' ELSE ‘没有此类产品’ END;
(2)IF(expr1,expr2,expr3)
如果expr1为真,则返回expr2;为假,则返回expr3.
(3)IFNULL(arg1,arg2);
如果arg1不为空,则返回arg1;为空,则返回arg2.
(4)NULLIF(arg1,arg2)
如果arg1=arg2,则返回NULL,否则,返回arg1.
(5)STRCMP(expr1,expr2)
如果expr1与expr2相等,返回0;expr1>expr2,返回1;expr1<expr2,返回-1.