zen of coding

BETWEEN AND SQL syntax in CakePHP

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.

Read More »
%d bloggers like this: