Magento

Hi,
I want to use lower case function for name in product collection. For example

But this is not working. Can anyone help ?

Why not do it PHP

Actually I need to do it in query as filter for example

MySQL is case insensitive. For example I have extra spaces and wrong case in the following select statement which works

kiatng, mysql is case insensitive but spaces are not trimmed

Try this:

You have an extra “ in your original statement.

I think addExpressionAttributeToFilter is not available

hi

try this

or

Thanks,
ilm_abhishek

I need to trim column value also

$write = Mage::getSingleton(’core/resource’)->getConnection(’core_write’);

// now $write is an instance of Zend_Db_Adapter_Abstract
$readresult=$write->query("SELECT *
FROM `pepitashop_catalog_product_super_attribute_pricing` , `pepitashop_catalog_product_entity`,`pepitashop_catalog_product_super_attribute`
WHERE
`pepitashop_catalog_product_super_attribute`.product_super_attribute_id = `pepitashop_catalog_product_super_attribute_pricing`.product_super_attribute_id
AND
pepitashop_catalog_product_super_attribute.product_id = `pepitashop_catalog_product_entity`.entity_id
AND pepitashop_catalog_product_super_attribute.product_id = ‘“.$_id.”’
ORDER BY `pepitashop_catalog_product_super_attribute_pricing`.pricing_value DESC
LIMIT 0 , 30 “);

while ($row = $readresult->fetch() ) {
$categoryIds[]=$row[’id’];
}

I have come up with this solution :