I need to write a question use Magento ORM applying functions at condition like this:
SELECT * WHERE REPLACE(street, ' ', '') = 'Streetac'.
I try using regular expressions but I have problem with case sensitive.
I need a function like this: addExpressionFieldToSelect, but I need to use this function at condition.
In that the query return all this cases.
'House 12' = 'hOuse 12' = 'house 12 ' = HouSe 12 '