where子句在mysql查询中不起作用

roejwanj 于 2021-06-21 发布在 Mysql

关注(0)|答案(1)|浏览(431)

我已经实现了一个mysql查询，其中有很多where条件，但是没有给出正确的结果。我必须找到用户id不等于7的数据，但是它给出了用户id为7的结果。下面是我运行的两个查询，但是没有给出正确的结果。

SELECT * 
FROM `tr_truck` 
WHERE (`user_id` != 7 AND `body_type_id` = 1 ) 
        AND ( `truck_capacity_id` = 1 AND `truck_wheel_id` = 2 ) 
        OR ( `truck_wheel_id` = 2 AND `truck_length_id` = 1 ) 
        OR (`truck_capacity_id` = 1 AND `truck_length_id` = 1 )

我运行的另一个查询是

SELECT * 
FROM `tr_truck` 
WHERE ( `truck_capacity_id` = 1 AND `truck_wheel_id` = 2 ) 
        OR ( `truck_wheel_id` = 2 AND `truck_length_id` = 1 ) 
        OR (`truck_capacity_id` = 1 AND `truck_length_id` = 1 ) 
        AND `user_id` NOT IN (7) AND `body_type_id` = 1

我还尝试用！=但没用。这是我数据库结果的截图。https://prnt.sc/kskl08

mysql

来源：https://stackoverflow.com/questions/52252410/where-clause-not-working-in-my-mysql-query

1条答案

按热度按时间

jyztefdp1#

你能试试这个吗，我重新安排一下括号的排列
查询1

SELECT * 
    FROM `tr_truck` 
    WHERE (`user_id` != 7 AND `body_type_id` = 1 AND `truck_capacity_id` = 1 AND `truck_wheel_id` = 2 ) 
    AND
     ( (`truck_wheel_id` = 2 AND `truck_length_id` = 1 ) 
   OR ( `truck_capacity_id` = 1 AND `truck_length_id` = 1 ))

查询2

SELECT * 
FROM `tr_truck` 
WHERE (( `truck_capacity_id` = 1 AND `truck_wheel_id` = 2 ) 
        OR ( `truck_wheel_id` = 2 AND `truck_length_id` = 1 ) 
        OR (`truck_capacity_id` = 1 AND `truck_length_id` = 1 ) )
        AND (`user_id` NOT IN (7) AND `body_type_id` = 1 )

赞(0）回复(0）举报 2021-06-21

我来回答

where子句在mysql查询中不起作用

1条答案

相关问题

热门标签

最新问答