SQL CASE [Column] WHEN IN ('case1', 'case2') THEN 'oops' END？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/2004147/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
SQL CASE [Column] WHEN IN ('case1', 'case2') THEN 'oops' END?
提问by Shimmy Weitzhandler
Is there a way to check a CASE when it's in an array:
有没有办法在数组中检查 CASE：
SELECT CASE [Option] WHEN IN (1, 3, 99) THEN 'Wrong option' ELSE 'You go!' END
回答by jspcal
SELECT CASE WHEN [Option] IN (1, 3, 99) THEN 'Wrong option' ELSE 'You go' END
回答by Rob Farley
You can use the CASE WHEN <predicate> THEN <value> ... ENDoption, rather than the CASE <value> WHEN <value> THEN <value> ... ENDoption.
您可以使用CASE WHEN <predicate> THEN <value> ... END选项，而不是CASE <value> WHEN <value> THEN <value> ... END选项。
SELECT CASE WHEN [Option] IN (1, 3, 99) THEN 'Wrong option' ELSE 'You go!' END
... but if the values are in a table, you could just do an outer join (and
...但是如果值在一个表中，你可以做一个外连接（和
CASE WHEN t.Value IS NULL THEN 'Not in list' ELSE 'In list' END
, or
， 或者
CASE WHEN EXISTS (SELECT * FROM yourTable t WHERE t.value = [Option]) THEN 'Bad' ELSE 'Ok' END
...without a join.
...没有加入。
