Tip: toggling a boolean database column

[eluser]sophistry[/eluser]
the bitwise operator XOR would work for this too :-)

Code:

UPDATE mytable SET column=1 XOR column WHERE [condition];