my $query = "SELECT field1,field2 FROM my_table WHERE LEFT(field3) = '$var'";