如何在where中使用case when?
CASE WHEN
a.PageType= 'Cate ' AND a.CurrFolder IS NULL
THEN a.Cateid = 34
ELSE a.id = 33
END
[解决办法]
where (CASE WHEN
a.PageType= 'Cate ' AND a.CurrFolder IS NULL
THEN a.Cateid
ELSE a.id +1
END ) =34