Re: How to order by days of the week, but not alphabetically in this query

[Brian Kotek]

I'm not sure about MySQL, but in Oracle you can do this easily,
assuming I am understanding correctly what you need, maybe a
similar solution is available for MySQL?

<CFQUERY Name="GetDays" Datasource="#DSN#">
Select WS_WeekDay
from weeklyschedule
order by
  case
  when WS_WeekDay eq 'Sunday' then 1
  when WS_WeekDay eq 'Monday' then 2
  when WS_WeekDay eq 'Tuesday' then 3
  when WS_WeekDay eq 'Wednesday' then 4
  when WS_WeekDay eq 'Thursday' then 5
  when WS_WeekDay eq 'Friday' then 6
  when WS_WeekDay eq 'Saturday' then 7  
  end
</CFQUERY>

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---