CASE ... WHEN ... THEN ... ELSE ... END

'expression'=>"@CASE WHEN FIND_IN_SET('EmailValidated', `State`)>0 THEN CONCAT('[已验证]', `AccountEmail`) ELSE `AccountEmail` END@",
posted on 2010-11-17 11:16  小炒花生米  阅读(216)  评论(0)  编辑  收藏  举报