Topic awaiting preservation: Select column using first letter. (Page 1 of 1)

I'm trying to only select the rows from a table where the first column called "name" is only of a letter.

So basically if I pass page.php?name=a

I get every listing that starts with the letter a. And if I pass b instead I get that. I know how to filter the query to limit it that way, but I really want to limit the query so I only pull what I want to optimize database access.

How else do you want to filter it, you didn't say?

If you just want to limit the amount you get back just use

LIMIT 5;

or what ever amount you want returned from you query.

-Butcher-