my @vals =("artist1", "artist2"); my $sth = $db->prepare(q{SELECT * FROM Songs WHERE Songs.Artist LIKE '%'||?||'%' OR Songs.Artist LIKE '%'||?||'%'});# suggestion from Jenda my $results = $sth->execute( @vals ) or die("Failed to Execute SQL");