Re: where x in (a,b,c)

[prev] [thread] [next] [Date index for 2005/04/08]

On Apr 8, 2005 10:49 AM, Barry Dancis <bdancis@xxxxxxx.xxx> wrote:
>     Is there a way to do a retrieve or search using cdbi for a subset of the
> records using an In operator, i.e. is there something like: 
>   
> my @people = People->retrieve(Name In qw (Ralph Jane Egbert); 

You can do that with Class::DBI::AbstractSearch

my @people = People->search_where(
             Name => { -in => [ qw (Ralph Jane Egbert) ] },
);

Cheers,

Cees