Hi,
Currently for a blog platform I have:
year=YEAR
month=TINYINT
day=TINYINT
timestamp=INT
I was contemplating using the TIMESTAMP type.
To get previous usage like yearly monthly etc archives I would do:
WHERE author=4 AND YEAR(timestamp)=2008 AND MONTH(timestamp)=4
Would this utilize an index on INDEX(author, timestamp) or would the functions YEAR() and MONTH() which extract kill the index usage?
Cheers!