mysql :ordering table with day names
Posted
by Meko
on Stack Overflow
See other posts from Stack Overflow
or by Meko
Published on 2010-05-09T20:35:57Z
Indexed on
2010/05/09
20:38 UTC
Read the original article
Hit count: 169
Hi.I am trying to get day of names with and correct order like Monday ,Tuesday.. But in my table I have records that after Monday comes Friday or I have Thursday between two Tuesday .I want to order them like Monday ,Monday ,Tuesday ,Tuesday, Wednesday so on .But I don`t want to group them.
I used this query but it does not make order
select Day_Name from mydb.schedule where Room_NO=(510) And Week_NO =(1)
it outputs
Monday
Monday
Tuesday
Wednesday
Wednesday
Tuesday
Thursday
Thursday
Thursday
how can I correct it?
© Stack Overflow or respective owner