SV: [PHP-DB] Selecting between using letters
| From: | Henrik Hornemann | Date: | Tue, 30 Dec 2003 08:29:25 +0000 |
| Subject: | SV: [PHP-DB] Selecting between using letters | ||
| Groups: | php.db php.general | ||
| Request: | Send a blank email to php-db+get-32219@lists.php.net to get a copy of this message | ||
How about
Select LastName from sometable where LastName >= 'A' and LastName <'F'
Hth Henrik Hornemann
-----Oprindelig meddelelse-----
Fra: Doug Parker [mailto:drparker@phreshdesign.com]
Sendt: 29. december 2003 23:18
Til: php-db@lists.php.net; php-general@lists.php.net
Emne: [PHP-DB] 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.
------------------------------------------------------------
http://www.phreshdesign.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php