[...]
my $queryStatementHandler = $dbh->prepare("SELECT field1,field2 FROM my_table WHERE LEFT(field3, ?) = ?");
$query->bind_param(1, $value_1);
$query->bind_param(2, $var);
$query->execute();
[...]