Question

我在表格客户中列出了以下数据:

------------------
|id|client|status|
------------------
|1 |331   |  0   |
|2 |331   |  1   |
|3 |331   |  2   |
|4 |331   |  1   |
|5 |331   |  0   |
|6 |222   |  0   |
------------------

我想从客户为331人、具有地位0或1的表客户中提取所有领域。这意味着我将因此而获得1 2 4 5美元。

但是,当我使用这 s时,

$query = mysql_query("select * from clients where client=331 AND status=0 or status=1")

相反,我正在获得1,4,5,6美元。

数据的正确途径是什么?

Answer 1

用途

select * from clients where client=331 AND (status=0 or status=1)

The order of precedence for logical operators is (Not, And, then Or). As And has higher precedence than Or your query is effectively

select * from clients where (client=331 AND status=0) or status=1

这不是理想的语义。也可以使用

select * from clients where client=331 AND status in (0,1)

Answer 2

使用母体。替换:

select * from clients where client=331 AND status=0 or status=1

注

select * from clients where client=331 AND (status=0 or status=1)

The first query looks for records which have either (client = 331 and status = 0), or status = 1.
The second query looks for records which have client = 331 and either (status = 0 or status = 1).

Answer 3

$query = mysql_query("select * from clients where client=331 AND (status=0 or status=1)")

页: 1

Answer 4

让经营者优先!

Your criteria should be..
client=331 AND (status=0 or status=1)

或者为了完整。

Answer 5

Parenthetic statements are your friend. SQL AND before OR as AND has higher precedence than OR, to overcome this you need to use these things ( )

You are looking for

SELECT * FROM clients WHERE client=331 AND (status=0 OR status=1)

友情链接