$select = $this->sql->select('ville');
        $select->columns(array('id', 'precision_annexe','ville','code_postal'));
        $select->order('vue DESC');
        $select->limit('5');

        $where = new Where();
        $where->like(new \Zend\Db\Sql\Predicate\Expression('lcase(ville)'), $nom.'%');
        $select->where($where);
        $where2 = new Where();
        $where->like('lcase(precision_annexe)', $nom.'%');
        $select->where($where,Predicate\PredicateSet::OP_OR);
        if(preg_match('#^.*? .*?$#is',$nom)){
            $nom = str_replace(' ','-',$nom);
            $where = new Where();
            $where->like(new \Zend\Db\Sql\Predicate\Expression('lcase(ville)'), $nom.'%');
            $select->where($where,Predicate\PredicateSet::OP_OR);
            $where2 = new Where();
            $where->like('lcase(precision_annexe)', $nom.'%');
            $select->where($where,Predicate\PredicateSet::OP_OR);
        }