CODEWITHSUNDEEP
databasezend-frameworkzend-db
Alwin Kesler
Alwin Kesler

Reputation: 1520

ZF Db Append to column

Im trying to make an update similar to this with Zend_Db:

UPDATE `TABLE` SET
  column = column + 'new value'
WHERE
  foo = 'bar'

any of you have done this before? is it possible? Thanks

Upvotes: 2

Views: 181

Answers (1)

drew010
drew010

Reputation: 69977

With the help of Zend_Db_Expr this is possible.

Example:

$newValue = 101;
$data     = array('column' =>
                  new Zend_Db_Expr($db->quoteInto('column + ?', $newValue)));
$where    = $db->quoteInto('foo = ?', 'bar');

$updated = $db->update('TABLE', $data, $where);

Resulting Query:

UPDATE `TABLE` SET `column` = `column` + 101 WHERE `foo` = 'bar';

If you are asking how to append a string, then the code is similar, but you cannot use the + operator when dealing with character data, instead use CONCAT().

For example, change the $data array to this:

$data  = array('varcharCol' =>
               new Zend_Db_Expr(
                   $db->quoteInto('CONCAT(varcharCol, ?)', ' append more text!')
         ));

Upvotes: 2

Related Questions