Consider the folowing dataset: +----+------------+-------------+-------------+---------------+ | id | Name | Location | OnOffFlag | Description | +----+------------+-------------+-------------+---------------+ | 1 | Paper | Cabinet | 0 | Blah | | 2 | Plastic | Cabinet | 0 | Blah | | 3 | China | Cabinet | 1 | Blah | | 4 | Glass | Cabinet | 0 | Blah | | 5 | China | Table | 0 | Blah | | 6 | China | Cabinet | 1 | Blah | +----+------------+-------------+-------------+---------------+
Is there a way to, using a single query, set the OnOffFlag to 1 for the record that matches [Name=China AND Location=Table] at the same time setting the OnOffFlag to 0 for records that match [Name=China AND Location!=Table]? I know I can do it in 2 queries but I am curious to know if it can actually be done in 1. thnx, Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
