my $sql = qq[
    UPDATE `myTable` 
    SET `va` = ?, `vb` = ? 
    WHERE `vc` = ?
];
while (my $record = <$input>)
{
    chomp $record;
    my ($val1, $val2, $val3) = (split(/\|/,$record))[1,3,5];
    $db->query($sql, $val1, $val2, $val3);
}