Re: Querying 2 Values Form 1 Column in DBIx::Class

[poj]

See http://search.cpan.org/~ilmari/SQL-Abstract-1.84/lib/SQL/Abstract.pm#Logic_and_nesting_operators

my @results = $schema->resultset( 'People1' )->search({
       Name => [ -and => {-like => '%Franklin%'},
                         {-like => '%Linsey%'}]
    }
);

poj

[phildeman]

Thanks poj,

That is exactly what I was looking for!

I finally got it working using the code below, but your way is cleaner and less code!</p

my $results = $schema->resultset( 'People' )->search({
            Name => {  like => '%Franklin%' }
      },

if($results) {
     $results = $results->search( { Name => {like => '%Linsey%' } } );
}

my @result_objs = $results->all;

Thanks again!

-Phil-