[Solved] Mysql functions in zend 2

by 


/* DB Adapter get and SQL object create */
$adapter = GlobalAdapterFeature::getStaticAdapter();
$sql = new \Zend\Db\Sql\Sql($adapter);

/* Select object create */
$select = new \Zend\Db\Sql\Select();
$select->from('states');
$select->where->addPredicate(
    new \Zend\Db\Sql\Predicate\Expression(
        'TRIM(LOWER(state_name)) = ?',
        'noida'
    )
);

/* Select object convert to string and execute */
$queryString = $sql->getSqlStringForSqlObject($select);
$result = $adapter->query($queryString, Adapter::QUERY_MODE_EXECUTE);

1

solved Mysql functions in zend 2