Hi,
I have a MySQL tables with a fields of names.
I would like to make a alphabet by taking the first caracter of each word once... I need something like I could get using:
SELECT DISTINCT name FROM names WHERE name LIKE 'a%' ORDER BY name
But I don't what the list of words but only the DISTINCT first letter... this because I want to get out a list like:
a - b - c - d - ....
Where users could click a have listed only records that begins by that letter.
Thank you for any help about!
Fabio
