Cakephp 2.X Concat?

#1

HI,
Is it possible to update field with existing value plus something?
Like:

$this->User->updateAll([‘User.deleted’ => 1, ‘User.notes’ => CONCAT(‘User.notes’ ," ‘" . $str . "’")],
[‘User.’ . $data_type => $emails]);

I’m rying to implement query like :slight_smile:

UPDATE Users
set deleted =1,
notes = CONCAT(notes, $str)
WHERE email IN ($emails)

Thank you.