SELECT *
FROM People
WHERE Name like '%Franklin%' and Name like '%Linsey%'

##</code><code>##

@results = $schema->resultset( 'Peoplel' )->search({
             Name => { like => '%Franklin%' },
             Name => { like => '%Linsey'%' }
          }
 );