October 12th, 2012, 10:51 AM
Order by for String numbers
I am having following values in class_name column of the student table.
But when I write following query:
It returns as:
select class_name from student order by class_name
But I want the O/P as below:
Please help me.
Thanks in Advance...!!
Last edited by Guelphdad; October 12th, 2012 at 11:24 AM.
Reason: swapped code for mysql in display
October 12th, 2012, 11:25 AM
ORDER BY class_name + 0
October 12th, 2012, 11:53 AM
Thanks Very much Guelphdad.