mysql - 执行 where 子句

Question

我有这张客户表:

+----------+----------+---------+
| cliecode | cliename | deleted |
+----------+----------+---------+
|    00001 | ABC      |         |
|    00002 | DEF      |         |
|    00003 | GHI      | yes     |
|    00004 | JKL      |         |
+----------+----------+---------+

我正在执行这样的搜索查询:

SELECT * 
FROM client 
WHERE deleted ='' 
      AND cliecode LIKE '%$_POST[key]%' OR cliename LIKE '%$_POST[key]%' 

我想在 like 条件之前先获取 deleted = ''。我怎样才能做到这一点？谢谢。

Answer 1

然后将您的 OR 条件分组，将它们放在括号内，

select  * 
from    client 
where   deleted ='' and 
       (cliecode like '%$_POST[key]%' or cliename like '%$_POST[key]%')