title: How do I filter a magento collection by a select drop-down attribute?
body: <p>In magento, I have an attribute called cl_designer, which is a select drop-down option. I want to  filter the products collection on it, like this:</p>
  
  <pre><code>$collection = Mage::getModel('catalog/product')-&gt;getCollection();
  $collection-&gt;addAttributeToFilter('cl_designer', array('like' =&gt; $filter));
  </code></pre>
  
  <p>But it doesn't work! When I print out the query with $collection->getselect(), I see that it is comparing $filter to catalog_product_entity_int.value. But this is wrong, because for select options, catalog_product_entity_int.value is the option_id, NOT the value. So how do I make it filter on the actual option value?</p>