MySQL: Simple way to toggle a value of an int field

Question

I know how to do this, but i think I'll overcomplicate it with double selects and so on.

How can you do this (example in pseudo-sql)

UPDATE some_table SET an_int_value = (an_int_value==1 ? 0 : 1);

It must be an int value due to some other functionality, but how do you do it in a simple way?

vartec_60711 · Answer

UPDATE some_table SET an_int_value = IF(an_int_value=1, 0, 1);

user_67332 · Answer

UPDATE some_table SET an_int_value = IF(an_int_value=1, 0, 1)

Eric_P_65070 · Answer

In this case, you could use an XOR type operation:

UPDATE some_table SET an_int_value = an_int_value XOR 1

This is assuming that an_int_value will always be 1 or 0 though.

user_41665 · Answer

Another option:

UPDATE some_table SET an_int_value = ABS(an_int_value - 1);

user_4779649 · Answer

UPDATE
    `some_table`
SET
    `an_int_value` = `an_int_value` ^ 1

Testing:

SELECT 0 ^ 1; /* returns 1 */

SELECT 1 ^ 1; /* returns 0 */