I need sql help

[bmcoll3278]

hey guys here is my query string
mysql_query("SELECT * FROM names WHERE name like '%A%';ORDER BY name ASC");

This Table row contains a single word name My query works but it will pull all names with a (a) in them. Can someone tell me how to match only the first letter of the name so I can display all names with a or b or c you get the idea.

Thanks in advance

[ishkey]

"ORDER BY Keyword"
The ORDER BY keyword sort the records in ascending order by default.
If you want to sort the records in a descending order, you can use the DESC keyword.

SELECT column_name(s)
FROM table_name
ORDER BY column_name(s) ASC|DESC