Sorting Results by First letter only

[keith73]

I have a database of users that I'd like to sort through by first letter.
For example, there would be links to reference each letter of the alphabet, someone clicks on A and all usernames starting with a are returned, likewise if you click on B, C, etc.

I would like to find some way of doing this in the MySQL command to eliminate an extra step, but if need be I will write a function.

Thanks in advance,
- Keith

[mikeq]

You could have links like

<a href="myscript.php?letter=A">A</a>
etc

Then in myscript.php the variable $letter will be available. Just pass that to a MySQL query

select * from names where username like '$letter%'