mysql - 在sql查询中混合使用CASE和IN

Question

我已经阅读了其他问题，但我认为它们与我的情况并不“完全”相似。

我想做的是类似于 SELECT ... WHERE some_field_to_compare IN (CASE WHEN something something THEN ('1','2','3') ELSE ('0')) 的查询

这样查询就可以变成SELECT ... WHERE some_field_to_compare IN ('1','2','3')或SELECT ... WHERE some_field_to_compare IN ('0')取决于something something 。如何才能做到这一点？非常感谢...

编辑:按照亚历克斯的要求!! :))

SELECT cake FROM cakes WHERE cake_magic_number IN (CASE WHEN cake_frosty = 'no_frosty' THEN ('1','2','3') WHEN cake_frosty = 'is_frosty' THEN ('1','2') WHEN cake_frosty = 'wow... good frosty!' THEN ('2') ... END)

Answer 1

您可以使用或:

when (<something> and some_field_to_compare IN ('1','2','3') ) or
     (not <something> and some_field_to_compare IN ('0'))