This is how you’d write a BETWEEN… AND… SQL query in a cake-like way.
The example should be pretty much self explanatory:
$this->Post->find(‘all’, array(‘conditions’=>array(‘Post.id BETWEEN ? AND ?’ => array(1, 10))));
Note, that CakePHP will quote the numeric values depending on the field type in your DB.