Mysql Information

Question: Mysql search by date?

(Posted by: karthik on 2010-03-03 11:17:38)

In mysql database, the date records are like year or month or day only. suppose year and month only or year and day only or month and day only. So, we are select any type of method for retrieving records.So, how to create a query for achieve this. Please give a example code.

Posted by: Arch on 2010-03-03, 11:48:02

Karthik, I'm not a 100% sure how your database is designed. are you using the Date type? or do you have separate columns for each, Year, Month, and Day? If you are storing the date in a Date type column, simply append this at the end of your query: ORDER BY Date (assuming that's the name of the column). If you are storing all 3 separate, append the following at the end of your query: ORDER BY Year, Month, Day (replace with your column names, and you can arrange them in whichever order you want them sorted).

Posted by: Jeff P on 2010-03-03, 11:24:17

I'm not going to give you the answer, but you'll find it in this discussion thread.