I have created a multi select attribute and assigned this to attribute set. Attribute is showing in product search results but I am unable to include this into product collection filtering as well as into addAttributeToSelct Here is the section I am using this attribute to filter the prodcut collection.
$collection = Mage::getModel("catalog/product") ->getCollection() ->addAttributeToSelect(array('sku','speciality','name')) ->addFieldToFilter('speciality', array('eq' => $speciality)); echo $collection->getSelect();
And in my browser I have the following result for select query
SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `e`.`sku`, `e`.`name` FROM `catalog_product_flat_3` AS `e` WHERE (e.status = 1)