Way to select rows which fall on a specific day?

Question

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

Answer 1

Look up the DAYOFWEEK() function here in the MySQL Online Docs

Answer 2

MySQL DAYOFWEEK function.

E.g. to select Mondays:

SELECT * FROM foo WHERE DAYOFWEEK(bar) = 2

Answer 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