For example to execute query like

UPDATE tableName SET column1 = 'abc',column2 = 'xyz' WHERE column ='1';

In symfony you can do it this way

$c = new Criteria();
$c->add(MyTablePeer::COLUMN,1);
$c->add(MyTablePeer::COLUMN1,'abc');
$c->add(MyTablePeer::COLUMN2,'xyz');
MyTablePeer::doUpdate($c);

Thanks
One thought on “update query in symphony (Method 2)”
  1. How this criteria works with more than one ‘where’ conditions like this?
    WHERE column1 =’1′ and column2 =’1′

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.