LastName LIKE '[A-K]*' for one case, and
LastName LIKE '[L-Z]*' for the other case.
[download]

Hello

Thanks for reply. I tried using your advice, but no luck. Im sort of a MySQL newbie and confused on how I would put that statement with mine.

$sql = "SELECT * FROM mailtodo where date = '$INPUT{'date'}' AND lastn
+ame LIKE '[A-K]*'";
[download]

The statement above returns no results, but should. I need the where date syntax because I'm also sorting the data by date. Thanks,

Anthony

@A_K = grep /^[A-K]/, @query_results;
@L_Z = grep /^[L-Z]/, @query_results;
[download]

my @A_K;
my @L_Z;
my $aref = \@A_K;
while ( my $row = $dbh->fetchrow_arrayref ) {
    $aref = \@L_Z if ( $$row[$last_name_col] =~ /^L/ );
    push @$aref, [ @$row ];
}
[download]

update: Note that the latter both methods assume that you're still using the "ORDER BY" clause in your SQL; in the former, the sequence is preserved in both subsets; in the latter, once you hit a name that starts with "L", you switch to the second array for collecting all remaining rows.

The latter solution itches me because you're doing the test for each row, even after you switched. Note it will also fail if there's no name starting with an L in the output.

I'd do something like:

while (my $row = $dbh -> fetchrow_arrayref) {
    if ($row -> [$last_name_col] =~ /^[L-Z]/) {
        push @L_Z => $row;
        while (my $row = $dbh -> fetch_arrayref) {
            push @L_Z => $row;
        }
        last;
    }
    push @A_K => $row;
}
[download]