[Dbix-class] NOT IN queries

Cory Watson jheephat at gmail.com
Thu Oct 1 20:25:38 GMT 2009


On Thu, Oct 1, 2009 at 3:22 PM, Cory Watson <jheephat at gmail.com> wrote:
> On Thu, Oct 1, 2009 at 3:18 PM, Dermot <paikkos at googlemail.com> wrote:
>> Hi,
>>
>> I suspect the answer to the question, "can I use
>> DBIx::Class::Resultset to do a sql query like this":
>>
>> SELECT * FROM countries where iso2letter NOT IN ('GB','IE', 'HK','US');
>
> Isn't it just:
>
> ->search({ iso2letter => { '-not-in' => [qw(GB IE HK US)] })

Er, Rob's response is right.  That's not_in. (underscore)

-- 
Cory 'G' Watson
http://www.onemogin.com



More information about the DBIx-Class mailing list