I have a mysql table called schedules with a field called hour which is a char(2) and one called sequence which is int(8). I would like to do
SELECT * FROM schedules ORDERED BY hour AND sequence;
When I use the above command the hour sort is not correct because it is sorting as a char field as opposed to integer and the sequence sort is highest number first. I need What do I need to change or do. Thanks!