Select * FROM ... WHERE DAYOFWEEK(datecol)=7 -----Original Message----- From: Ben Miller [mailto:bmiller@xxxxxxxxxxxxxxxxx] Sent: Tuesday, August 05, 2008 8:10 PM To: PHP. DB Mail List Subject: 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 (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.138 / Virus Database: 270.5.12/1592 - Release Date: 05/08/2008 06:03 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
