sql - MySQL:关于 SELECT WHERE AND/OR 的问题

Question

我正在尝试编写一个从三个不同事件返回相同结果的查询，但我认为我做错了。我可以针对一个事件 ID 运行我的查询并且它有效。我怎样才能选择所有三个？这是我到目前为止所拥有的:

SELECT * FROM `Registrations` 
WHERE `Role` = "Attendee" AND `RegistrationStatus_ID` = "1" AND `DigSignature` IS NULL
    AND `Event_ID` = "147" OR `Event_ID` = "155" OR `Event_ID` = "160"

Answer 1

SELECT * 
FROM `Registrations`  
WHERE `Role` = "Attendee" 
    AND `RegistrationStatus_ID` = "1" 
    AND `DigSignature` IS NULL 
    AND `Event_ID` in ("147", "155", "160")