Sorting by first letter

wxdqz

New Member
I'm running mysql and php4. I was wondering if there was a fast way to query the database and return results based only on their first letter. Like if i wanted to return every item that started with A or every item that started with B. I know I could do a complete query and then sort into an array by doing a substring search on the first letter of each item but that seems rather time consuming for the server especially if the database returns 1000 items on the query. Is there a faster way to do this? Thanks
 
Back
Top