I am trying to create a view in MySQL based on the current day of the week. I am creating a table to keep track of tasks based on the day of the week. For example, some tasks will happen every Tuesday, some will happen on Wednesday and Friday, etc.

I decided to set the table up with a column for each day of the week. If the task needs to be executed on that day I will store a 1 in the column, otherwise it will be a 0. The table looks like this: 

```
| ID | Monday | Tuesday | Wednesday | Thursday | Friday |    Task     |
-----------------------------------
| 1  |   0    |    1    |     0     |     0    |   0    | "SomeTask"  |
| 2  |   0    |    0    |     1     |     0    |   1    | "SomeTask"  |
| 3  |   0    |    1    |     0     |     0    |   0    | "SomeTask"  |

```

I would like to create a SELECT statement that will be used in a view to show the tasks that need to be executed on the current day. In other words, today is Tuesday so I would like to a query that will get the rows with the ID of 1 and 3 to show up.

I tried the following , but it didn't work:

```
SELECT * FROM MyTasks WHERE DAYNAME(curdate()) = 1

```

Is there a better way to format the table? Is there anyway to use DAYNAME in the WHERE clause? Any suggestions?