Zend-framework DB: OR instead of AND operator

Question

have such zend query:

$select = $this->_table
               ->select()
               ->where('title LIKE  ?', '%'.$searchWord.'%')
               ->where('description LIKE  ?', '%'.$searchWord.'%')
               ->where('verified=1 AND activated=1');

In other words it looks like:

SELECT `some_table`.* FROM `some_table` WHERE (title LIKE '%nice house%') AND (description LIKE '%nice house%') AND (verified=1 AND activated=1)

If I have couple AND sentences, zend connect it through AND operator. How can I connect it with OR operator ? Cause I need:

...(title LIKE '%nice house%') OR (description LIKE '%nice house%')...

Your help would be appreciated.

I think just sql.. operator precedence will be taken into account, coz these queries will be converted to plain sql. I am just suggesting as I too have this doubt and came here — Rohith Raveendran
– Rohith Raveendran, Commented Jul 2, 2013 at 9:46

Yanick Rochon · Accepted Answer · 2010-08-21 22:20:41Z

26

$this->_table->select()->orWhere($condition);

To build more complexe queries (i.g. sub-conditions) you might have to use $this->table->getAdapter()->quoteInto() and write your SELECT manually.

edited Aug 21, 2010 at 22:20

answered Aug 21, 2010 at 7:45

Yanick Rochon

53.8k30 gold badges147 silver badges232 bronze badges

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

Comments

Andreas · Accepted Answer · 2016-05-28 07:10:31Z

4

The others answers here do not work (anymore?), the current solution is to call nest() and unnest() in the where clause:

$select->where
    ->nest()
        ->equalTo('column1', 1)
        ->or
        ->equalTo('column2', 2)
    ->unnest()
    ->and
    ->equalTo('column3', 3);

answered May 28, 2016 at 7:10

Andreas

2,84727 silver badges30 bronze badges

1 Comment

Eric Seastrand Over a year ago

That syntax looks to be for Zend FW 2.2. framework.zend.com/apidoc/2.2/classes/…

SagarPPanchal · Accepted Answer · 2014-01-31 06:29:20Z

1

I have implemented your zend query

$select = $this->_table
               ->select()
               ->where('title LIKE  ?', '%'.$searchWord.'%')
               ->ORwhere('description LIKE  ?', '%'.$searchWord.'%')
               ->where('verified=1 AND activated=1');

answered Jan 31, 2014 at 6:29

SagarPPanchal

10.2k6 gold badges36 silver badges66 bronze badges

Collectives™ on Stack Overflow

Zend-framework DB: OR instead of AND operator

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related