Mysql Alphabetical

[pickle]

I was wondering if there was a way to get information from a mysql database by the first letter of the entry?

[barand]

For example, to query a employee phone directory table to list all names beginning with A, or B etc.

When processing the submitted form

$search = $_POST["initial"] . "%";
SELECT * FROM table WHERE name LIKE '$search'

hth