Q:

How to display first character in drop down list

I would like to display only the first characters in the drop down list.
For example,
I have names like Adam,Harry,James in mysql table. I've created a dropdown list showing the names Adam,Harry etc. But, I want to display only their first characters like A,H,J etc. in the drop down list. Is there any way to do it?

A:

use MySQL LEFT :-
LEFT(names , 1)

query like that :-
select LEFT(names , 1) from table 

