Hi all. I have a table with ~250,000 entries. Each entry has an associated
year value, which could be any year in the past 200 or so...
I am creating a PHP page to display the years that have items, ordered by
$sql="SELECT year, SUBSTRING(year,2,2) AS decade FROM `items` GROUP BY
decade, ORDER BY year DESC;"
This query takes around 0.5s to execute. Results:
I display these items as links (using anchors) to the full decade results
further down the page, where I list each and every year I have items for ...