mysql - 如何在 MySQL 中使用关键字 IN OR 内部连接 ​​3 个表？

Question

如何正确使用此 IN OR 选择语句？ (除 where bdt.active='yes' 外，一切正常)

SELECT bdt.*, specials.*, stars.* 
FROM bdt INNER JOIN specials ON  bdt.id = specials.id 
         INNER JOIN stars ON specials.id=stars.id 
   WHERE bdt.active='yes' 
   AND  bdt.business_type IN ('entertainment') 
    OR  bdt.business_subtype IN  ('entertainment')  
    OR  bdt.subtype2 IN ('entertainment') 
    OR  specials.type IN ('entertainment')

Answer 1

您只需要在第二个 AND 条件中使用方括号 ()，如下所示:

SELECT bdt.*, specials.*, stars.* 
FROM bdt INNER JOIN specials ON  bdt.id = specials.id 
         INNER JOIN stars ON specials.id=stars.id 
   WHERE bdt.active='yes' 
   AND (bdt.business_type IN ('entertainment') 
    OR  bdt.business_subtype IN  ('entertainment')  
    OR  bdt.subtype2 IN ('entertainment') 
    OR  specials.type IN ('entertainment'))