|go ahead... be a heretic|
MySQL Alphabetical order with DBIby perleager (Pilgrim)
|on Nov 15, 2002 at 13:30 UTC||Need Help??|
perleager has asked for the wisdom of the Perl Monks concerning the following question:
I have data that I want to sort by alphabetical order. I want two lists, A-K list and a L-Z list.
The variable I will be sorting is the Last name.
I have a data looks like this:
John Smith 443-333
Alan Jones 242-344
Henry Love 245-333
My data is stored in MySQL and is in the column "Name". How would I sort this by last name? Should I split the variable from the array, then add the last name string to a new array, then sort that array?