Zend Framework DB Complex Where Or condition

Question

How can I do a SELECT like this using Zend Framework Table.

SELECT * FROM table WHERE (field1 = 0 AND field2 = 1) OR (field2 = 0 AND field3 = 1)

Using just $table->orWhere() dont allow me to do multiple conditions inside of a parentheses

Zachary Schuessler · Accepted Answer · 2012-07-26 19:08:04Z

2

To build complex queries:

// Zend_Db_Table
$this->getAdapter()->quoteInto('(field1 = 1 AND field2 =2) OR ...');

Here is a comprehensive article for more information.

answered Jul 26, 2012 at 19:08

3,6722 gold badges33 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1