ORDER by ASC not working!
Posted: Sun Aug 01, 2004 6:46 pm
I'm a beginner in the world of databases but I did have enough sense to consult the MySql Manual before asking this simple question. No help there.
Here's my problem: I am trying to sort a column that contains the days of a month. When I sort the column (order by day asc) it puts a day of (for example) 2 AFTER a day like 19.
Here's my question: Is there any way that I can query the database and let it know that even though there is no leading zero before the 2, it is still lower than 19?
Thanx.
Here's my problem: I am trying to sort a column that contains the days of a month. When I sort the column (order by day asc) it puts a day of (for example) 2 AFTER a day like 19.
Here's my question: Is there any way that I can query the database and let it know that even though there is no leading zero before the 2, it is still lower than 19?
Thanx.