How To Sort Text as a Number in MySQL
erics, Posted July 11th, 2013 at 12:47:43pm
select theField from theTable order by theField+0;
~OR~
select theField from theTable order by CAST(theField AS UNSIGNED);
Categories: How-To's, Technology 0, Add, Cast, howto, Number, sort, String, text(), tips, Zero
Leave Your Comment
All fields marked with "*" are required.