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

Filed under:
|
|

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

Related posts about mysql

Related posts about order