Sorting record by alphabetic follow by number in one column
Posted: Fri Jun 30, 2006 11:24 pm
hi there,
I have a column which contain numbers and alphabets, as i know mysql will sort the numbers first then follow by alphabet. I would like to sort the records by alphabetic then follow by numbers in ascending, can this be done in the query?
I have a column which contain numbers and alphabets, as i know mysql will sort the numbers first then follow by alphabet. I would like to sort the records by alphabetic then follow by numbers in ascending, can this be done in the query?