Magento 1.x – Use MySQL functions on Magento collections


Sometimes, you may need to use mysql functions in your query, to add any of them on your Magento collections, you could use the addExpressionAttributeToSelect statement.

Below, i will attach some examples:

CONCAT

MONTH

LOCATE