The difficulty you're having is that what you call alphanumeric, MySQL sees as just a
string. How about a computed field with some usage of MySQL's substring_index function
to parse the string into pieces, if you know they will always have the given delimiter
(the -, in your example), and then
Is there a better answer than making sure the mixed keys have enough leading
zeros in the numeric sub-field to suppress the string comparison effect?
ergo (if you know you will never have ten thousand records):
XY-0001-BLAH
XY-0002-BLAH
XY-0003-BLAH
XY-0004-BLAH
XY-0005-BLAH
XY-0006-BLAH
XY-0007
Hi All,
Ive been searching the archives and the documentation but dont really know
the terminology im looking for, or even if its do-able or not so I figure I
would just ask here instead..
I have a list of records in a table, and one of the fields is alpha
numeric. They look like this...
