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 Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.