Cacher is the code snippet organizer for pro developers

<?php

$_products = Mage::getResourceModel('catalog/product_collection')
 ->addAttributeToSelect(array('name', 'product_url', 'small_image'))
 ->addAttributeToFilter('sku', array('like' => 'UX%'))
 ->load();
 
$collection = Mage::getModel('catalog/product')->getCollection();
$collection->addAttributeToFilter('updated_at', array('gteq' =>$first));
$collection->addAttributeToFilter('updated_at', array('lteq' => $last));
 
 
// Equals: eq
$_products->addAttributeToFilter('status', array('eq' => 1)); // Using the operator
$_products->addAttributeToFilter('status', 1); // Without using the operator

// Not Equals - neq
$_products->addAttributeToFilter('sku', array('neq' => 'test-product'));

// Like - like
$_products->addAttributeToFilter('sku', array('like' => 'UX%'));

// Not Like - nlike
$_products->addAttributeToFilter('sku', array('nlike' => 'err-prod%'));

// In - in
$_products->addAttributeToFilter('id', array('in' => array(1,4,98)));

// Not In - nin
$_products->addAttributeToFilter('id', array('nin' => array(1,4,98)));

//NULL - null
$_products->addAttributeToFilter('description', array('null' => true));

// Not NULL - notnull
$_products->addAttributeToFilter('description', array('notnull' => true));

// Greater Than - gt
$_products->addAttributeToFilter('id', array('gt' => 5));

// Less Than - lt
$_products->addAttributeToFilter('id', array('lt' => 5));

// Greater Than or Equals To- gteq
$_products->addAttributeToFilter('id', array('gteq' => 5));

// Less Than or Equals To - lteq
$_products->addAttributeToFilter('id', array('lteq' => 5));