my $combinedquery = "
SELECT 
    whatever 
FROM 
    mytable 
WHERE 
    CONCAT(name,middle,surname) = ?";

my $sth = $dbh->prepare($combinedquery);
$sth->execute>("$name$middle$surname");
# check if you got any results