How to make nested AND's and OR's in DB queries in Zend Framework?

Question

I was wondering how I can get something like this:

SELECT * from `table` WHERE id='1' AND (title='hurr' OR title='durr')

in Zend framework? To my knowledge there are only where() functions, which together make AND relationships and orWhere() which adds an OR rule, but if used together, a select like this:

$select=$this->select()->where("id='1'")->where("title='hurr'")->orWhere("title='durr'");

This would create a query like this

SELECT * from `table` WHERE id='1' AND title='hurr' OR title='durr'

Which is something completely different.

Alex Pliutau · Accepted Answer · 2011-04-07 15:41:28Z

4

$select = $this->select()->where('id = 1')->where("title='durr' OR title='hurr'");

$select = $this->select()->where('id = 1')->where('title IN (?)', array('durr', 'hurr'));

answered Apr 7, 2011 at 15:41

Alex Pliutau

22k28 gold badges115 silver badges144 bronze badges

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

Comments

Shakti Singh · Accepted Answer · 2011-04-07 15:40:31Z

1

You can do something like

$select=$this->select()->where("id='1'")->where("title='hurr' OR title='durr'");

You can check the manual

answered Apr 7, 2011 at 15:40

Shakti Singh

86.8k21 gold badges142 silver badges156 bronze badges

Collectives™ on Stack Overflow

How to make nested AND's and OR's in DB queries in Zend Framework?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related