OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
possible combine update statement

From: Hiep Nguyen (hiepee.ucr.edu)
Date: Wed Dec 05 2007 - 07:48:53 CST

hi list,

i have a loop to update my table:

update tbl_idea set col1 = 'text1', col2 = NOW() where ideaID = 1;
update tbl_idea set col1 = 'text2', col2 = NOW() where ideaID = 5;
...
update tbl_idea set col1 = 'textzzz', col2 = NOW() where ideaID = XXX;

my question is can i combine above statements into one statement so i can
only do update only once?

thanks,
T. Hiep

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql