[Dbix-class] Increment MySQL field

[Byron Young]

Ben Vinnerd wrote on 2009-05-15:
> Hey,
> 
> I have the following SQL to increment a field by 100:
> 
> update account set balance = balance + 100
> 
> I can increment a field with DBIC, like so:
> 
> $account->update({balance => \'balance + 100'});
> 
> Is there a better/cleaner way of doing this in DBIC?
> 
> Cheers,
> 
> Ben

Ben, how about this?

  $account->update({balance => $account->balance + 100});

-Byron