Between Clause in where condition

[eluser]darkhouse[/eluser]
I've actually wanted a feature like this, so that I could do something like

Code:

$this->db->where_between('id', 100, 200);

Though I've just done what Mike said to do and never had a problem.

I don't think it's a simple feat to extend the active record class, but what if you made a helper function that was like this:

Code:

function where_between($field, $min, $max){
     $CI = get_instance();
     return $CI->db->where("$field BETWEEN $min AND $max");
}