[Dbix-class] using functions

Octavian Rasnita orasnita at gmail.com
Sat Jan 6 22:37:27 GMT 2007


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




More information about the Dbix-class mailing list