[mysql] SQL order string as number
컨텐츠 정보
- 18,612 조회
- 0 추천
-
목록
본문
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
관련자료
-
링크
댓글 0
등록된 댓글이 없습니다.