Hi I have a column in a table in mysql database say Issue.Now this column consists of numbers but its type in the database is varchar.Dont blame me , I didnt designed the database.Now I have to sort my result set based on this column. Usin SOL's order by doesnt seems to work because as its varchar so 900>1100 ..Is there any query which treats this column as integer.Or i have to resort to php.
if possible change the column type
if not possible try to ORDER BY column + 0
if that doesn't work you have to resort it in php
