<div>
<div class="content wysiwyg-content">
I've got a database table that has a row with a bunch of dates in it - each representing an item that was entered on that date. &nbsp;So, there are hundreds of entries, each with a date formatted as &quot;YYYY-MM-DD&quot;.<br />
<br />
What I'd like to do is get a return of the individual months that have entries. &nbsp;So, say there were:<br />
<br />
5 various entries in December 2015<br />
3 entries in February 2016<br />
4 entries in August 2016<br />
2 Entries in December 2016<br />
<br />
return back something that would denote:<br />
<br />
December 2015, February 2016, August 2016, December 2016.<br />
<br />
The number of entries per month is irrelevant...just the fact that there are entries in that month.<br />
<br />
How would I go about doing that query? &nbsp;Somehow trim the day off so it's just returning &quot;2016-12&quot; ... or?<br />
<br />
Thanks in advance!
</div>
</div>


I've got a database table that has a row with a bunch of dates in it - each representing an item that was entered on that date.  So, there are hundreds of entries, each with a date formatted as "YYYY-MM-DD".

What I'd like to do is get a return of the individual months that have entries.  So, say there were:

5 various entries in December 2015
3 entries in February 2016
4 entries in August 2016
2 Entries in December 2016

return back something that would denote:

December 2015, February 2016, August 2016, December 2016.

The number of entries per month is irrelevant...just the fact that there are entries in that month.

How would I go about doing that query?  Somehow trim the day off so it's just returning "2016-12" ... or?

Thanks in advance!

MySQL Grouping

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.