SQL 选择多个 AND

Question

我有一个很长的 sql 语句，我试图添加一些 AND 条件，但它不起作用。

这是我的声明：

if($cat=="att") { $sqlCatC = "INNER JOIN yt_att_data CAT
    ON CAT.busID = R.id AND CAT.subcatID = 5 AND CAT.subcatID = 136 AND CAT.deleted = 0"; }

//Get RegionInfo busID based on region, approved
    $sql= "SELECT DISTINCT CAT.busID,R.id,companyName,membershipID,addressID,city,logo,descriptionShort FROM yt_Business_RegInfo R
    $sqlReg
    INNER JOIN yt_Business_Seasons S
    ON R.id = S.busID AND S.deleted = 0
    INNER JOIN yt_Business_Address A
    ON R.addressID = A.id
    INNER JOIN yt_Business_Membership M
    ON R.membershipID = M.id AND M.approved = 1
    $sqlCatC
    WHERE R.deleted = 0
    ORDER BY R.companyName ASC LIMIT $start, $limit";

在顶部 $sqlCatC 中，我尝试添加一个 AND 条件，其中 CAT.subcatID 等于 5 和 136。它适用于检查单个 CAT.subcatID，但不适用于两个。任何建议将不胜感激。

Answer 1

使用 IN 关键字，如下所示：

CAT.subcatID IN(5,136)

替换两个 AND。

Answer 2

subcatID 不能同时为 5 和 136，必须使用 OR 而不是 AND。

将其更改为并尝试

ON CAT.busID = R.id AND 
(CAT.subcatID = 5 OR CAT.subcatID = 136) 
AND CAT.deleted = 0";

，或者您可以使用 IN 使其简短

 ON CAT.busID = R.id AND 
 CAT.subcatID IN ('5','136') 
    AND CAT.deleted = 0";

Answer 3

当您将同一列等于两个不同的值时，不能应用 AND 条件。
使用 OR 条件。

将 $sqlCatC 更改为如下：

$sqlCatC = "INNER JOIN yt_att_data CAT  ON CAT.busID = R.id AND (CAT.subcatID = 5 OR CAT.subcatID = 136) AND CAT.deleted = 0";