Hi,

I'd like to use the "BETWEEN" operator in my select statement. (ex : SELECT * FROM product WHERE price BETWEEN x AND y) Currently i don't see how i can do this. So I write my own function, I give it to you the code, but i think there is a better way to do the same thing cause in fact i just want to quote 2 values separatly. It should be better if the where function do something like that.

 
    /**
    * $select->between('price BETWEEN ? ', 100, 200);
    */

    public function between($cond)
    {
        if (func_num_args() > 1) {
            $min  = $this->_adapter->quote(func_get_arg(1));
            $max  = $this->_adapter->quote(func_get_arg(2));
            $cond = str_replace('?', $min . ' AND ' . $max, $cond);
        }

        if ($this->_parts[self::WHERE]) {
            $this->_parts[self::WHERE][] = "AND ($cond)";
        } else {
            $this->_parts[self::WHERE][] = "($cond)";
        }

        return $this;
    }