Query question
| From: | Beauford | Date: | Sat, 28 Oct 2006 22:01:31 +0000 |
| Subject: | Query question | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-243804@lists.php.net to get a copy of this message | ||
Hi,
I have a MySQL database with a date field and a bunch of other fields. The
date field is in the format - 01/01/2006. What I want to do is query the
database and create a table that shows just the year and how many instances
of the year there is. I have been taxing my brain for a simple solution, but
just not getting it. Any suggestions?
Thanks
Example output.
Year Count
2002 5
2003 8
2004 9
2005 15
2006 22
ps - I get this information sent to me and I can't change any of the data. I
just enter it in the db and then hopefully do the query on it.