# User input
my ($name,$middle,$surname) = ('George', 'Washington', 'Clark');

my $query = "
SELECT 
    whatever 
FROM
    mytable 
WHERE 
    name = ? 
    AND middle = ?
    AND surname = ?";
my $sth = $dbh->prepare($query);
$sth->execute>($name, $middle, $surname);
# check if you got any results


##</code><code>##

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

##</code><code>##

my $query = "
SELECT 
    whatever 
FROM 
    mytable 
WHERE 
    SOUNDEX(name) = SOUNDEX(?) 
    AND SOUNDEX(middle) = SOUNDEX(?)
    AND SOUNDEX(surname) = SOUNDEX(?)";

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

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

$sth = $dbh->prepare($combinedquery);
$sth->execute>("$name$middle$surname");