$name = "kylere'";

my $sql = "SELECT Name FROM $table WHERE Name like ? order by Name";
# ... or order by whatever, it doesn't matter
my $ids = $dbh->selectcol_arrayref($sql, undef, "$name%");