Multiple Row Update (Different WHERE clauses)

[tgrk35]

Is there a way to consolidate this:

UPDATE `departments` (`number`,`name`,`area_of_responsibility`) VALUES (1501005,'University Ombuds',11001) WHERE `number` = 1501005 LIMIT 1;

UPDATE `departments` (`number`,`name`,`area_of_responsibility`) VALUES (1501005,'University Ombuds',11001) WHERE `number` = 1501005 LIMIT 1;

UPDATE `departments` (`number`,`name`,`area_of_responsibility`) VALUES (1501005,'University Ombuds',11001) WHERE `number` = 1501005 LIMIT 1;

...into one statements such as this:

UPDATE `departments` (`number`,`name`,`area_of_responsibility`) VALUES ((1501005,'University Ombuds',11001) WHERE `number` = 1501005),((1501005,'University Ombuds',11001) WHERE `number` = 1501005),((1501005,'University Ombuds',11001) WHERE `number` = 1501005);

Of course the values wouldn't all be the same, I'm just too lazy to piece together another statement with a different WHERE clause.

Ideas?

Thanks for any and all help

[chazzy]

provide a more concrete example, as I don't see what you're trying to consolidate there.

also, as a comment, the use of that format for update, while it might work on mysql, doesn't work on other DBMS. you should probably stick w/ the ANSI standards.

[tgrk35]

UPDATE `departments` (`number`,`name`,`area_of_responsibility`) VALUES (1501005,'University Ombuds',11001) WHERE `number` = 1501005 LIMIT 1;

and

UPDATE `departments` (`number`,`name`,`area_of_responsibility`) VALUES (1516000,'Inst. Research & Planning',11001) WHERE `number` = 1516000 LIMIT 1;

consolidated into something like

UPDATE `departments` (`number`,`name`,`area_of_responsibility`) VALUES ((1501005,'University Ombuds',11001) WHERE `number` = 1501005), ((1516000,'Inst. Research & Planning`,11001) WHERE `number` = 1516000);

[chazzy]

Nope. This is the full syntax for update, from mysql's website

http://dev.mysql.com/doc/refman/5.0/en/update.html