ngs up or not.
Warren Vail
-Original Message-
From: Lowell Allen [mailto:[EMAIL PROTECTED]
Sent: Monday, December 29, 2003 2:25 PM
To: PHP
Subject: Re: [PHP] Selecting between using letters
> How would I create a select statement in MySQL that would return a range
of
> records from t
Doug Parker wrote:
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 appre
How about the following;
SELECT DISTINCT left( name, 1 ) AS idx, count( * )
FROM users
GROUP BY idx
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 M
> 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.
4 matches
Mail list logo
