List:General Discussion« Previous MessageNext Message »
From:Jacque Scott Date:March 23 2004 7:37pm
Subject:Re: Sorting with an alpha numeric field.
View as plain text  
I will give that a try.
 
Thank you

>>> Dan Nelson <dnelson@stripped> 3/23/2004 11:31:50 AM
> >>>
In the last episode (Mar 23), Jacque Scott said:
> I have something like A001C, B689, B1001 etc...

Aah. This question pops up about once a year, usually under the
subject of "Natural Sorting". There's no builtin function for doing
this, but one solution would be to write a UDF that finds runs of
numeric characters, and zero-pads them out to, say, 5 digits. Then
using ORDER BY padnumbers(myfield), your three sample values will look
like

A00001C
B00689
B01001

, and mysql will sort them right.

-- 
Dan Nelson
dnelson@stripped 


Thread
Sorting with an alpha numeric field.Jacque Scott23 Mar
  • Re: Sorting with an alpha numeric field.Dan Nelson23 Mar
  • Re: Sorting with an alpha numeric field.Garth Webb23 Mar
Re: Sorting with an alpha numeric field.Jacque Scott23 Mar
  • Re: Sorting with an alpha numeric field.Dan Nelson23 Mar
    • RE: Sorting with an alpha numeric field.Erich Beyrent23 Mar
Re: Sorting with an alpha numeric field.Jacque Scott23 Mar