my $sth=$dbh->prepare('SELECT ... FROM ... WHERE SUBSTR(column, 1, ?) = ?');
$sth->execute(length($what), $what);