Returning an alphabetical list consisting of the first letter in MySQL

In a recent project, one task involved returning the unique first letter of the data held in a MySQL field in order to provide hyperlink navigation through the web-site as opposed to a drop down menu.

This was accomplished using the MySQL statement below;

SELECT DISTINCT (left( [field], 1 ) )FROM `[table]` ORDER BY [field]