Select * FROM ... WHERE DAYOFWEEK(datecol)=7

-----Original Message-----
From: Ben Miller [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 05, 2008 8:10 PM
To: PHP. DB Mail List
Subject: [PHP-DB] Date Translation in MySQL

I'm looking for a quick and simple way to query a MySQL database by date, or
more specifically, by day of the week.  My dates are stored in the DB in
YYYY-MM-DD HH:MM:SS format.  Question, is there a built-in for PHP or MySQL
that will take this column and return only Saturdays, for example, without
having to use PHP to find each of the last X number of Saturdays and then
for each Saturday, query the database?

In case it matters, I am running on PHP v 4.4.7 and MySQL version 4.1.22.

Thanks in advance.

PHP Database Mailing List (
To unsubscribe, visit:

No virus found in this incoming message.
Checked by AVG - 
Version: 8.0.138 / Virus Database: 270.5.12/1592 - Release Date: 05/08/2008

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to