Order table in day of week format
Im trying to order a table in day of the week format i.e. Monday, Tuesday....
My SQL in the record set is:
SELECT discipline, `day`, `from`, `to`, activity, venue
WHERE discipline = 'Trampoline'
ORDER BY `day`ASC
however this returns the table in alphabetical order which obvioulsy means the days are out of order.
Is there an easy way to change the SQL in the recordset to reorder the table?