Order by for String numbers

Dev Shed Forums Sponsor:

October 12th, 2012, 09:51 AM

Registered User

Join Date: Oct 2012

Posts: 2

Time spent in forums: 26 m 19 sec
Reputation Power: 0

Order by for String numbers

Hi,
I am having following values in class_name column of the student table.
5th,6th,7th,8th,9th,10th.

But when I write following query:

Code:

select class_name from student order by class_name

It returns as:
10th
5th
6th
7th
8th
9th

But I want the O/P as below:

5th
6th
7th
8th
9th
10th

Please help me.

Thanks in Advance...!!

Last edited by Guelphdad : October 12th, 2012 at 10:24 AM. Reason: swapped code for mysql in display

October 12th, 2012, 10:25 AM

Guelphdad

Hockey face

Join Date: Nov 2001

Location: St. Catharines, Canada

Posts: 8,141

Time spent in forums: 2 Months 3 Weeks 3 Days 20 h 34 m 13 sec
Reputation Power: 1315

try this:

Code:

ORDER BY class_name + 0

October 12th, 2012, 10:53 AM

Registered User

Join Date: Oct 2012

Posts: 2

Time spent in forums: 26 m 19 sec
Reputation Power: 0

Thanks

Thanks Very much Guelphdad.
It worked...

Viewing: Dev Shed Forums > Databases > MySQL Help > Order by for String numbers

Developer Shed Advertisers and Affiliates

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

Forum Jump