sql case条件判断
SELECT id, f1, f2, f3,
CASE f2 WHEN 'aa' THEN 'aa' ELSE 'xx' END state
FROM db.table ORDER BY id DESC
SELECT id, f1, f2, f3,
CASE WHEN f2 IN ('aa', 'bb') THEN 'yy' ELSE 'xx' END state
FROM db.table ORDER BY id DESC
SELECT id, f1, f2, f3,
CASE f2 WHEN 'aa' THEN 'aa' ELSE 'xx' END state
FROM db.table ORDER BY id DESC
SELECT id, f1, f2, f3,
CASE WHEN f2 IN ('aa', 'bb') THEN 'yy' ELSE 'xx' END state
FROM db.table ORDER BY id DESC
转载于:https://my.oschina.net/redhands/blog/3098621