$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: > > UPDATE `test` SET `field` = `filed`+100 WHERE `id` = 1 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---