[thelist] MySQL toggle

Tony Crockford tonyc at boldfish.co.uk
Mon Feb 16 12:46:11 CST 2004


Hi

long day - brain fading fast

is there such athing as a mysql query that will toggle a tinyint value?

i.e if field is 1 update to 0 if field is 0 update to 1.

I've tried googling and looking through the documentation, but I'm 
obviously not searching for the correct terminology.

TIA

Tony

-- 
listening to: "if you don't know me by now" by David Brent

http://www.xebit.net/


More information about the thelist mailing list