Echo Distinct?

[askeli]

Hi,

Any suggestions on speeding up a distinct?

each row in mysql has say one character in it a or b or j or r or 6 etc, im trying to retrieve distinct but its very slow, i have used group by which returns in the correct order but is still slow.

Goal, if the table has an "a" in it i want to echo a link to "a" but not hundreds of them, just one.

If the rows has no "a" it wont echo a link.

Its an A-Z links index i want but i dont want links to pages that have no reuslts,

im poor explaining but hope someone can help
Thankyou

[jusdrum]

Try indexing the field that you are searching. It should help speed things up.

[askeli]

Thanks, already indexed but still slow as over 100k rows.