I've seen this question posted in various forms on the web, but not in
such a way that I have found helpful. I have a column of data in the
following format name.xx.yy where the x's and y's represent numbers.
When selected by mySQL, the column is sorted in an odd way, given by the
following example:
name.10.2
name.1058.5
name.205.3
Obviously, in our day to day thinking, the order should appear as:
name.10.2
name.205.3
name.1058.5
Does anyone know a way to resort this data so that when it is displayed
it is in common numerical order using a simple SQL statement? The data
is being pulled from a mySQL database and being displayed in a php page.
Thank you,
Nate
