[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