glenelkins Posted September 2, 2009 Share Posted September 2, 2009 Hi How would i write a mysql query to select rows from a table using the "date" field in my where clause ( which is 0000-00-00 format ), but the year and month do not matter, just select a specific "day" only Link to comment https://forums.phpfreaks.com/topic/172820-select-items-from-specific-day/ Share on other sites More sharing options...
suresh64633 Posted September 3, 2009 Share Posted September 3, 2009 Hi, Try this SELECT * FROM tblName WHERE DAY( DateField) = DesireDate Thanks Link to comment https://forums.phpfreaks.com/topic/172820-select-items-from-specific-day/#findComment-911615 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.