Mysql query by weekday

I want to query by weekday in a given table on a column storing dates. E.g. select * from MY_TABLE where date_column is 'Monday'

I saw a DAYOFWEEK() function in mysql. But this only seems to manipulate the results of the query.

So is such a query even possible?

>Solution :

Use weekday name:

SELECT * 
FROM my_table 
WHERE DATE_FORMAT(date_column, '%W') = 'Monday';

Use weekday index:

SELECT * 
FROM my_table 
WHERE DAYOFWEEK(date_column) = 2 
-- WHERE WEEKDAY(date_column) = 0

Leave a Reply