Database

[mysql] SQL order string as number

페이지 정보

본문

I have numbers saved as VARCHAR to a MySQL database. I can not make them INT due to some other depending circumstances.

It is taking them as character not as number while sorting.

In database I have

1 2 3 4 5 6 7 8 9 10...

On my page it shows ordered list like this:

1 10 2 3 4 5 6 7 8 9

How can I make it appear ordered by numbers ascending?



---------------------------------------------------------------------------------


select col from yourtable
order by cast(col as unsigned)

or to force a conversion to number do:

select col from yourtable
order by col * 1

관련자료

등록된 댓글이 없습니다.
Today's proverb
인간을 사랑할 것. 아무리 나약한 인간이나 초라하고 불쌍한 인간도 사랑할 것. 그리고 그들을 심판하지 말 것. (생텍쥐페리)