sql - 一个相当简单的SQL问题

Question

表结构:

Table: People

| Name | Skill1     | Skill2     | Skill3     | Skill4     | Skill5     |
| Tom  | Cooking    | Cleaning   | Eating     |            |            | 
| Jane | Typing     | Cooking    | Sleeping   | Flirting   |            |
| John | Tennis     |            |            |            |            |

没有技能的地方就是NULL。出于某种原因，我使用以下 SQL 得到 0 个结果:

select Name from People
where Skill1 or Skill2 or Skill3 or Skill4 or Skill5 = 'Cooking';

我希望看到汤姆和简......但我没有，我做错了什么吗？

Answer 1

最短的语法可能是这个:

select Name 
from People 
where 'Cooking' IN (
  Skill1,
  Skill2,
  Skill3,
  Skill4,
  Skill5);