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

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

Thanks

Barry
----- Original Message ----- 
From: "Cees Hek" <ceeshek@xxxxx.xxx>
To: "Barry Dancis" <bdancis@xxxxxxx.xxx>
Cc: "class dbi list" <cdbi-talk@xxxxxx.xxxxx.xxx>
Sent: Friday, April 08, 2005 10:58 AM
Subject: Re: where x in (a,b,c)


> 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
>