how to 'toggle' a bit field (0 or 1)

[stevelionbird]

Hi everyone,

I'm looking for a way with one statement to change the value of a tinyint field (named 'is_archive') in a table to either:

zero if its current value is one
OR
one if its current value is zero

Is there a way to do this without having to first query the table to get the current value of 'is_archive'?

e.g.

update [i]table[/i] set is_archive = (is_archive = 1) ? 0 : 1 where [i]conditions[/i];

Thanks in advance,
Steve

 

[johnwm]

Try the NOT operator

update table set is_archive = NOT(is_archive) where conditions;

See

http://dev.mysql.com/doc/refman/5.1/en/logical-operators.html#operator_not

for details

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints

 

[r937]

oh! oh!

what about SET is_archive = 1 - is_archive



r937.com | rudy.ca