mySQL: So I have these daynames, Monday, Tuesday, etc. but I want to convert them to a number so I can compare. You can't do SELECT 'Monday' - 'Tuesday' but if I could turn 'Monday' into a 2 and 'Tuesday' into a 3 then I could. Oh, and I have no correponding full-date to go with the daynames. Any ideas?