I have a column of type varchar that stores many different numbers. Say for example there are 3 rows: 17.95, 199.95 and 139.95.How can i sort that field as numbers in mysql
See Question&Answers more detail:osI have a column of type varchar that stores many different numbers. Say for example there are 3 rows: 17.95, 199.95 and 139.95.How can i sort that field as numbers in mysql
See Question&Answers more detail:osQuickest, simplest? use * 1
select *
from tbl
order by number_as_char * 1
The other reasons for using * 1
are that it can