Re: possible combine update statement

2007-12-05 Thread Mark Rogers
Hiep Nguyen wrote: 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; Depending on what you mean by 't

Re: possible combine update statement

2007-12-05 Thread Baron Schwartz
On Dec 5, 2007 8:48 AM, Hiep Nguyen <[EMAIL PROTECTED]> wrote: > 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', c