Date: 05/02/05 (MySQL Communtiy)    Keywords: mysql, sql

So I have a strange problem. I have a table with a column that is day of the week as an integer. (0-6) Is there any good way to map those back onto actual day names (Sunday, Monday etc) in Mysql. Also is there a way to do this with season names?

Source: http://www.livejournal.com/community/mysql/55260.html