in 1 of database fields, have numbers include ordinal suffixes. i'm trying sort them ascending, since numbers include ordinal suffixes, string '101st' assigned greater value '1st', , similarly, '29th' greater value '2d'.
does know how might work around this, without removing ordinal suffixes of each digit?
order cast(field unsigned) 
Comments
Post a Comment