Skip to content

Instantly share code, notes, and snippets.

@theshane
Created February 22, 2017 02:06
Show Gist options
  • Save theshane/b782cf7c5bb6f21c83f0210bffcfc9a2 to your computer and use it in GitHub Desktop.
Save theshane/b782cf7c5bb6f21c83f0210bffcfc9a2 to your computer and use it in GitHub Desktop.
HOW TO DO ‘IN’ AND ‘NOT IN’ IN DBIX::CLASS
my $search = $schema>resultset('Table')->search(
{ column_1 => { 'in' => [ 105, 106, 73, 74, 99, 75 ] },
column_2 => { 'not in' => [ 45,25,28] },
column_3 => { 'not in' => \@array}
}
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment