Re: Selecting between using letters
| From: | Thorsten Schmidt | Date: | Mon, 29 Dec 2003 22:38:00 +0000 |
| Subject: | Re: Selecting between using letters | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-173453@lists.php.net to get a copy of this message | ||
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 appreciated.
------------------------------------------------------------
http://www.phreshdesign.com
SELECT * FROM user WHERE lastname > 'A' AND lastname < 'E'