[Dbix-class] NOT IN queries

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


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)] })

I'm throwing that out from memory...

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



More information about the DBIx-Class mailing list