ORDER Day in a Week

Question

I have table named timetable which consists Day in it. The data that enter are randomly such as monday friday tuesday and so on. Therefore i want to pull out to php in order starting from monday tuesday and so on.

 ORDER BY FIELD(<fieldname>, 'MONDAY', 'TUESDAY', 'WEDNESDAY', 'THURSDAY', 'FRIDAY', 'SATURDAY', 'SUNDAY');

i found out code above is used to solve the problem of mine. But somehow i didn't understand how to use it and what its mean by FIELD and fieldname.

is it suppose to be write like this?

   SELECT * FROM timetable WHERE NoStudent = '".$NoStudent."' Order By Day ('Monday', .......);

please help me. Thank you

You just need to put `ORDER BY FIELD(Day, 'Monday', ...)`. `FIELD` is part of the command syntax as opposed to a placeholder — Martin, Oct 03 '19 at 13:33
There's an excellent explanation of how it works here: https://dba.stackexchange.com/a/109126/26769 — Martin, Oct 03 '19 at 13:35
Thank you all of you for the explanation. It WORK!. thank you so much everyone. — killer boyz, Oct 03 '19 at 14:18

score -1 · Answer 1 · answered Oct 03 '19 at 13:36

-1

ORDER BY
     day ASC

use this may be It will help you

answered Oct 03 '19 at 13:36

Samir Paruthi

121
1
3
12

ORDER Day in a Week

1 Answers1