[RESOLVED] help with mysql statement

[vang]

hi,
i have a column containing date(24-Jan-10) in the mysql.
i wish to extract related data by month.
i do not want to add another column in the db for storing month.
How can i do so?

$sql = "SELECT * FROM table WHERE receive_date='Jan' "; ??

regards

[Weedpacket]

http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_month

[bradgrafelman]

Is the receive_date column a DATE column, or a VARCHAR column? If it's the latter... why? If you're storing a date why not use the DATE column type?

[vang]

hi,
the column is in date format.
i imported a whole list of data into mysql.

[bradgrafelman]

Let me rephrase that... If the data is in YYYY-MM-DD format, and the column type is MySQL's DATE type, then you can easily use one of the Date and Time Functions, such as MONTH() as Weedpacket pointed out.