| 140 | | - | #sh(php){{ |
|---|
| 141 | | - | $nest = $select->where->nest(); |
|---|
| 142 | | - | $nest2_1 = $nest->nest(); |
|---|
| 143 | | - | $nest2_1->equalTo("name", "yamada"); |
|---|
| 144 | | - | $nest2_1->__get(Zend\Db\Sql\Predicate\PredicateSet::OP_OR); |
|---|
| 145 | | - | $nest2_1->equalTo("name", "tanaka"); |
|---|
| 146 | | - | $nest2_1->unnest(); |
|---|
| 147 | | - | $nest->__get(Zend\Db\Sql\Predicate\PredicateSet::OP_AND); |
|---|
| 148 | | - | $nest2_2 = $nest->nest(); |
|---|
| 149 | | - | $nest2_2->equalTo("age", "10"); |
|---|
| 150 | | - | $nest2_2->__get(Zend\Db\Sql\Predicate\PredicateSet::OP_OR); |
|---|
| 151 | | - | $nest2_2->equalTo("age", "20"); |
|---|
| 152 | | - | $nest2_2->unnest(); |
|---|
| 153 | | - | $nest->unnest(); |
|---|
| 154 | | - | }} |
|---|
| 155 | | - | WHERE ((`name` = 'yamada' OR `name` = 'tanaka') AND (`age` = '10' OR `age` = '20')) |
|---|