How about the following;

SELECT DISTINCT left( name, 1 ) AS idx, count( * ) 
FROM users

produces a count of the names found for each letter, then you can make
decisions about your range of letters, like a max of 250 between letters, or
some such number.

Warren Vail

-----Original Message-----
From: Doug Parker [mailto:[EMAIL PROTECTED]
Sent: Monday, December 29, 2003 2:18 PM
Subject: [PHP] Selecting between using letters

How would I create a select statement in MySQL that would return a range of
records from the LastName field where the value starts with a designated
letter - for example, returning the range where the first letter of LastName
is between A and E...

Any help would be greatly appreciated.


PHP General Mailing List (
To unsubscribe, visit:

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to