Re: Selecting between using letters
| From: | Lowell Allen | Date: | Mon, 29 Dec 2003 22:25:15 +0000 |
| Subject: | Re: Selecting between using letters | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-173451@lists.php.net to get a copy of this message | ||
> 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.
$sql = "SELECT * FROM table WHERE LastName REGEXP '^[A-E]'";
HTH
--
Lowell Allen