i jeszcze dodatkowe przykłady

UserTable.php

<?php
        $this->tablegateway->select(function (\Zend\Db\Sql\Select $select) use ($params){
            // kolumna created = updated
            $select->where->equalTo('id','created');
            // i pole like zawiera cos tam szukanego
            $select->where->AND->like('name',"%".$params['search']."%");
            // i pole email jest test@test.pl albo z domeny @test.com
            $select->where->AND->NEST->equalTo('email','test@test.pl')->OR->like('email','%@test.com');
           // a do tego jeszcze parametr email malymi literkami równa ... itd
            $select->where->addPredicate(new \Zend\Db\Sql\Predicate\Expression("LOWER(email) = ?",$params['email']));

        });