The following comment was submitted to the MySQL Manual.
-----------------------------------------------------------------------
From: Baker Franke <befranke@stripped>
Regarding: http://www.mysql.com/php/manual.php3?section=UPDATE
Is it possible to do multiple updates in one
line. I have two values for two different keys
that I simply want to swap. Do I have to do two
separate update statements? I know the answer is
no, I just can't figure it out.
-----------------------------------------------------------------------
Regards,
MySQL Manual
--
MySQL Manual
+------------------------------------------------------------------+
| ____ __ _____ _____ ___ http://www.mysql.com/ |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| php-manual@stripped |
| /*/ /*/ /*/ \*\_ |*| |*||*| MySQL Manual |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Stockholm |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ Sweden |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+------------------------------------------------------------------+
