开发者

mysql: value can be "null", but not must be "specific_value"

开发者 https://www.devze.com 2023-02-18 14:31 出处:网络
I have a query like this: SELECT group.active, group.desc, group.group_id, hide_group.hide, hide_group.user_id

I have a query like this:

SELECT group.active, group.desc,
group.group_id, hide_group.hide,
hide_group.user_id
FROM group 
LEFT JOIN hide_group ON
     group.group_id=hide_group.group_id
WHERE group.active=1 
AND hide_group.user_id != 'test' 
OR hide_group.user_id IS NULL   
ORDER BY hide_group`.`user_id`  DESC

This completely ignores the active row for some reason? If I remove

and hide_group.user_id!='test'

It takes active=1 into account, but does not return right values. If I examine the first query, everything would be ok if the active condition w开发者_StackOverflow中文版ould be taken into account. Help!


Use the parentheses in the correct way when you deal with "and" and "or" together.


table name group, field name desc would not help

0

精彩评论

暂无评论...
验证码 换一张
取 消