mysql - 如何在查询中组合两个条件？

Question

我有一个问题

select 
    Cust_code, Cust_Name, Cust_City
from
    mgen_custcode
where
    Mgen_branch = '$bangalore'
        AND Cust_Name like '%$q%'
        or Cust_code like '%$q%'
order by Cust_Name

但每次它都会在 Mgen_branch 列中显示所有条目，无论是类加罗尔、海得拉巴还是金奈

感谢任何帮助

Answer 1

我认为这会解决您的问题:

select Cust_code,Cust_Name,Cust_City 
from mgen_custcode 
where Mgen_branch='$bangalore' 
      AND (Cust_Name like '%$q%' or Cust_code like '%$q%') 
order by Cust_Name

它将检查 Cust_Name 或 Cust_code

AND Mgen_branch