Way to select rows which fall on a specific day?


Way to select rows which fall on a specific day?



Is there a way in MySQL to select rows which fall on a specific day, as in Mondays, using a date column?




How to store a java.util.Date into a MySQL timestamp field in the UTC/GMT timezone?

1:



mysql php : switching between mysql databases is slow


MySQL - Where IN together with GROUP_CONCAT


Querying for N records associated with each record referenced by set of record keys

2:



Which tags are not in the database?
Look up the DAYOFWEEK() function here in the MySQL Online Docs.


3:


I assume you mean a specific Week Day Name, yes there is:. In mysql you can use DAYOFWEEK() - check the manual. In PHP you can use getdate() and for example do:. $date = getdate(); $weekday = $date[weekday]; - check the manual.



88 out of 100 based on 78 user ratings 478 reviews