Search Webmaster Help and Solution

Sorting on Varchar MySQL

Hi I want to sort in MySQL a Varchar Field.

The content of that field is below:
HHD01
HHD100
HHD02
HHD37
SAD55

I tried using +0 at the end of the order by field but it does not work

How can i sort it properly Numerically like this

HHD01
HHD02
HHD37
HHD100
SAD55


Let me know
thanks Hi I want to sort in MySQL a Varchar Field.

The content of that field is below:
HHD01
HHD100
HHD02
HHD37
SAD55

I tried using +0 at the end of the order by field but it does not work

How can i sort it properly Numerically like this

HHD01
HHD02
HHD37
HHD100
SAD55


Let me know
thanks

View Complete Thread with Replies

Related Items

Query failed: connection to localhost:3354 failed (errno=111, msg=Connection refused).