Share Coding

Tutorials, Problems, Stuffs …

How to order / sort number in MYSQL when you have 1, 10, 100?

Sometimes, when you order the record which contain 1, 10, 100

You want:

1F -> 10F -> 100F

But you get:

100F -> 10F -> 1F

 

or something like that.

 

Solution:

orderBy length(floor_name), floor_name ASC
Advertisements

One response to “How to order / sort number in MYSQL when you have 1, 10, 100?

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: