Between

Posted on December 18, 2017, 3:23 pm, by admin, under Magento 1.x, Tips.

gteq – greater than or equal (>=)
lteq – less then or equal (<=) gt – greater then (>)
lt – less (<) Doing BETWEEN with AND 

$result = Mage::getModel('modulename/tablename')
		->getCollection()
		->addFieldToFilter('field1',array('gteq' => $value))
		->addFieldToFilter('field2',array("lteq" => $value));

Doing BETWEEN with OR

$result = Mage::getModel('modulename/tablename')
		->getCollection()
		->addFieldToFilter(
			array('bin_start', 'bin_end'),
			array(
				array('gteq' => $binDigits),
				array('lteq' => $binDigits),
                            )
                        );
Comment (RSS)  |  Trackback

Leave a Reply

«
»