[Dbix-class] Multiple functions in WHERE clause

Michael Gray mjg17 at eng.cam.ac.uk
Wed Sep 20 13:04:34 CEST 2006


On Tue, 19 Sep 2006, Michael Gray wrote:

> Sorry, I'm going round in circles with this one.  How do I do a search 
> to result in:
> 
>  select * from people where soundex(surname) = soundex(?);

Answering my own question, this is easy with search_literal:

  $rset->search_literal('soundex(surname) = soundex(?)', $who);

But out of interest, can this be achieved with a search({}) spec??

-- 
Michael



More information about the Dbix-class mailing list