MySQL反向值（NOT运算符）

Question

Is there a function is MySQL that automatically UPDATEs the value to the opposite one (something like ! NOT operator in php), without fetching the data, changing the value and inserting it again.

Also, if this helps, i need it only for zeroes and ones if there is any other, simpler way.

!0 = 1
!1 = 0

Answer 1

For only 0 and 1 you can do

UPDATE myTable SET myValue= 1 - myValue    // 1 becomes 0, 0 becomes 1.

If you want to include -1 in the scheme as well, you can do

UPDATE myTable SET myValue= 1 - ABS(myValue)    // 1 and -1 become 0, 0 becomes 1.