Search [alphabetically, first letter] a | b | c | d | e.. ?

[Harlequin]

I'm new to the SQL searching thing and I've been trying to figure out a way to allow a user search via the first letter on a certain table, such as "title" or "topic" or something.


So by a user clicking a or b or c or d.. so on and so forth..

The result would bring back and alphabetical order of topics with -just- that letter (such as the example below).

If user clicks A, result is:

alien
alligator
ant
art
asp

If user clicks B, result is:

beast
bite
brake
butter

..

I'm assuming to get the function to go alphabetical, it'd be GROUP BY or ORDER BY with an ASC or DESC, but the searching via a first letter is kind of killing me.