[Dbix-class] NOT IN queries

Rob Kinyon rob.kinyon at gmail.com
Thu Oct 1 20:21:57 GMT 2009


On Thu, Oct 1, 2009 at 16:18, 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');

$countries_rs->search({ iso2letter => { -not_in => [ 'GB', 'IE', 'HK',
'UK' ] } });

You'll need a reasonably new DBIx::Class.

-- 
Thanks,
Rob Kinyon



More information about the DBIx-Class mailing list