Before:
Code: Select all
news | date | month | comments
yay! | 9-11 | jan | none
yay! | 9-11 | jul | none
yay! | 9-11 | dec | noneCode: Select all
select distinct month from newsCode: Select all
news | date | comments
yay! | 121020031155 | none
yay! | 111220031155 | none
yay! | 101120031155 | noneCode: Select all
SELECT DATE_FORMAT( date, '%m-%y' ) AS formatted_date DISTINCT formatted_date
FROM newsthanks,
-Nay