if ($input) { my $search = $DBH->prepare("SELECT * FROM tble WHERE CONCAT(NAME, ', ', AGE, ', ', COUNTRY) LIKE ?"); $search->execute($input); my $row; while (my $row = $search->fetchrow()) { print "$row\n"; } }