title: Magento - Sorting product collection
body: <p>I have a product collection which needs to be filtered. For this I have overridden the 'Mage_Catalog_Block_Product_List' and have the following code:</p>
  
  <pre><code>$collection = parent::_getProductCollection();
  $collection-&gt;addAttributeToFilter('language', array('in' =&gt; 
  array('B','C','E')));
  $collection-&gt;addAttributeToSort('language', 'DESC');
  
  return $this-&gt;_productCollection; 
  </code></pre>
  
  <p>On the front end this sorts in the form of E,C,B</p>
  
  <p>If I set the attribute to sort to 'ASC' the sort is in the form of B,C,E</p>
  
  <p>What I need however is to specify the order to E,B,C</p>
  
  <p>Is there any way this can be done?</p>
  
  <p>Thanks for your help.</p>
  
  <p>UPDATE</p>
  
  <p>I have tried fin_Set and looked at the link you sent. I tried the code:</p>
  
  <pre><code> $collection = parent::_getProductCollection();
   $collection-&gt;addAttributeToFilter('language', 
   array('finset'=&gt;'E','C,E,B'));
  
  return $this-&gt;_productCollection;
  </code></pre>
  
  <p>However this only shows products set as 'E' I have also tried the code you provided but I receive an empty product list. </p>