Webmaster Sucks Here I share stuff I used to suck at as a novice webmaster..

• Home
• About

Sort VARCHAR as INT in MySQL

Sometimes we can user VARCHAR for integer values. But when we need sort them, we have got big problem. Because VARCHAR's are string and it is sorting like a string.

Example:

1a 2a 3a 10b 20b 30b 15c 25c 35c (VARCHAR)

1a 10b 15c 2a 20b 25c 3a 30b 35c (Sorted)

We need

1a 2a 3a 10b 15c 20b 25c 30b 35c (Sorted integer)

We can do it with mysql CAST

SELECT vNumber FROM table ORDER BY CAST(`vNumber` AS SIGNED)

Reverse order

SELECT vNumber FROM table ORDER BY CAST(`vNumber` AS SIGNED) DESC

Other possible conversion types you may need are:

• BINARY[(N)]
• CHAR[(N)]
• DATE
• DATETIME
• DECIMAL[(M[,D])]
• SIGNED [INTEGER]
• TIME
• UNSIGNED [INTEGER]

You can find more about CAST -> MySQL docs here.

   

blogger chura clean br virus date calculation download download avast download avast free download avast free edition Google google analytics google badware google blocks google sitemap google twitter htaccess html5 html 5 br exploit br virus br virus removal internet explorer javascript jk.chura.pl jl.chura.pl remove jl.chura.pl virus Linux md5 msn MySQL password Php php 5.2.9 remove br virus replace search engine optimization SEO ssh trojan br twitter twitting virus virus exploit br virus html br WordPress yahoo