2 ms·

the last OR statement "OR 102" will evaluate true. It should be UPDATE permissions SET allow = 1 WHERE user=671156 AND permission=16 AND org=101 OR org=10

the last OR statement "OR 102" will evaluate true. It should be UPDATE permissions SET allow = 1 WHERE user=671156 AND permission=16 AND org=101 OR org=102;

slavik81 7y ago
You and fazzone have posted different answers. I'm a little unclear on which matches the original intent, but your where clause is equivalent to: (user=671156 AND permission=16 AND org=101) OR (org=102)
ummonk 7y ago
That is still wrong and would apply to everyone in org 102
- conro1108 7y ago
  Applying to everyone in org 102 is the intended behavior no? The slip-up would be the 'OR 102' which would just evaluate to true.
  - larkeith 7y ago
    The example query is supposed to match a single account, not an org.