[Dbix-class] using functions

[Octavian Rasnita]

From: "Len Jaffe" <lenjaffe at jaffesystems.com>
>> Hi,
>>
>> I am trying to use the following condition but without success. Is it
>> possible to do it with DBIx::Class?
>>
>> select count(*) where
>> substring(title, 1, 4)='XXXX';
>
> select count(*) where title like 'XXXX%'

Oh thanks. I didn't remember about LIKE. It works fine for what I need, but 
as a future reference, is it possible to use functions like substring with 
DBIx::Class?

For the moment I have used the "where => ...". Is it the only way?

Thanks.


Octavian