Set the flag I write SET status=status|? How do I clear the flag? Usually I write SET status=status&( – 1 ^?) but ^ is illegal in sqlite. How can I clear the flag or use an exclusive OR?
sqlite does not seem to have an xor operator. You can simulate it using the following method:
select (~(a&b))&(a|b)
For example, when covering 1111(15) with 0100(4):
select (~(15&4))&(15|4)
The answer is 1011(11). So you can clear the flag.
< /p>
Set the flag I write SET status=status|? How do I clear the flag? Usually I write SET status=status&( – 1 ^?) but ^ is illegal in sqlite. How can I clear the flag or use an exclusive OR?
SQLite does not seem to have the xor operator. You can simulate it using the following method:
select (~( a&b))&(a|b)
For example, when covering 1111(15) with 0100(4):
select (~(15&4 ))&(15|4)
The answer is 1011(11). So you can clear the flag.