[thelist] MySQL toggle

Maximillian Schwanekamp anaxamaxan at neptunewebworks.com
Mon Feb 16 13:02:14 CST 2004


UPDATE tablename SET tinyintcol = NOT(tinyintcol) WHERE...

Maximillian Von Schwanekamp
Enabling microbusiness and infopreneurs
NeptuneWebworks.com :: InfoMarketingInsider.net 
voice: 541-302-1438
fax: 208-730-6504


-----Original Message-----
From: Tony Crockford [mailto:tonyc at boldfish.co.uk]
Sent: Monday, February 16, 2004 10:46 AM
To: thelist at lists.evolt.org
Subject: [thelist] MySQL toggle


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/
-- 
* * Please support the community that supports you.  * *
http://evolt.org/help_support_evolt/

For unsubscribe and other options, including the Tip Harvester 
and archives of thelist go to: http://lists.evolt.org 
Workers of the Web, evolt ! 






More information about the thelist mailing list