FuelPHP Forums

(EDIT, TO BAD i can't edit the title!.. ) Hi there, I've setup a tinyint (day) field in my team table. The field helps storing the day of the week. (just static, nothing to do with dates). Of course i could use mysql 's ENUM but that's the evil way. I want to do it clean. So is it possible to alternate the ORM query for selecting the day field?

SELECT ELT(day, 'monday', 'tuesday', 'wednesday', 'thursday', 'friday', 'saturday', 'sunday') FROM team;

If day = 5, this query returns 'friday' If day = 7, this query returns 'sunday'
If it isn't possible, then what's the best practise in such situation. I bet a lot of people have 'tinyint' fields for little properties. Using the ELT function it is easy to translate...