Sorting Numeric Values in php

Question

hifriends I want to sorting the numbers in 123......101112 in this order i'm also using select * from table_name order by column name; I get the answer is 110111223..... How can i get this order... help me

Dipika · Answer

This is bcoz your column is VARCHAR or NVARCHAR. The column should be INT or one that allows numbers only. For you this might be the solution SELECT (col_name * 1) AS new_name FROM table_name order by new_name A little hack!!

Vsd Vsd · Answer

SELECT (ID * 1) AS sort FROM Tbl_employee order by sort

Gokul · Answer

thanks for reply vasanti i appreciate you