Order by Mixed Alpha/Numeric
This is a discussion on Order by Mixed Alpha/Numeric within the MySQL General forum forums, part of the MySQL category; --> Hello, we have a column in a table, called tag numbers, which start with numerical and alpha characters, IE: ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 07:02 AM
| ||||
| ||||
 Order by Mixed Alpha/Numeric Hello, we have a column in a table, called tag numbers, which start with numerical and alpha characters, IE: 012345 123456 LH12345 KB055698 47899901 MO558585 ........ etc. now what I need to do is to display all the tag numbers, but order by their alpha prefix, either DESC or ASC. What is the correct syntax to order by the alpha characters, first?? TIA, Mike(mickalo)Blezien =============================== Thunder Rain Internet Publishing Providing Internet Solution that Work http://www.thunder-rain.com ===============================      |
Linear Mode
