update filed based on current value

2008-11-13 Thread [EMAIL PROTECTED]
Is there any way to update a row in a table based on current value? I would like to do something like this: UPDATE `test` SET `field` = `filed`+100 WHERE `id` = 1 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups

Re: update filed based on current value

2008-11-13 Thread grigri
$this-Test-updateAll( array( 'Test.field' = 'Test.field+100' ), array( 'Test.id' = 1 ) ); hth grigri On Nov 13, 12:34 pm, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Is there any way to update a row in a table based on current value? I would like to do something like this: