update enum flip?

ironCode · #1 (**permalink**) 10-25-06, 08:57

I have a data field that is a simple enum('0','1') is it possible to update it and just flip the results? So for example i have a 0 and want to simply flip it to 1 but on the other hand it might be a 1 and i want to flip it to a 0 with the same query. Is this possible or would i have to use the scripting language and do a normal update?

Any help would be great!

r937 · #2 (**permalink**) 10-25-06, 09:36

Code:

update daTable
   set daEnum = case when daEnum='0' then '1' else '0' end

ironCode · #3 (**permalink**) 10-25-06, 09:43

woot that was exactly what i was looking for. Thanks!

I was trying to do it with a sub-select and wasn't able to get it done lol

Internet Services

Web Development

Digital Marketing

Consumer Tech