Perhaps try one of these: ->delete('table', new Zend_Db_Expr('col1 IN ("1","2")'));
OR ->delete('table', new Zend_Db_Expr('col1 IN ( SELECT col2 FROM table2 WHERE col3="someValue")'); The prevalent idea here is to use Zend_Db_Expr instead of a plain string: http://framework.zend.com/manual/en/zend.db.html (search for Zend_Db_Expr) If you pass in an array of id's they will be ANDed together to form your where part. -ralph On 12/29/08 8:26 AM, "S. Alexandre Lemaire" <sae...@saeven.net> wrote: > Hello Folks, > > Is there a provision in the ->delete( 'table', ... ) to handle IN > clauses or subqueries? > > eg: > > 1. DELETE FROM table1 WHERE col1 IN ( '1', '2' ) > > 2. DELETE FROM table1 WHERE col1 IN ( SELECT col2 FROM table2 WHERE > col3=? ) > > > Or is it only capable of handling basic equalities? > > Thanks. > Alex > > -- Ralph Schindler Software Engineer | ralph.schind...@zend.com Zend Framework | http://framework.zend.com/