Posted: Wed Oct 17, 2007 10:31 am
Both suggestions worked great. Is there a good reason for using one over the other?
For my SQL query to pull all the data by year only, I've looked through the MySQL manual and spotted the YEAR function. It doesn't give an example of it in a query, but am I right in assuming it works similiar to other functions like SUM?
For my SQL query to pull all the data by year only, I've looked through the MySQL manual and spotted the YEAR function. It doesn't give an example of it in a query, but am I right in assuming it works similiar to other functions like SUM?