Re: php-db Digest 30 Dec 2003 12:07:25 -0000 Issue 2191

[Jeremy Shovan <jeremy@xxxxxxxxxxxxx>]

Try this:

select LastName from MyTable where left(LastName,1) >= 'a' and 
left(LastName,1) < 'f';

> How about
>
> Select LastName from sometable where LastName >= 'A' and LastName <'F'
>
> Hth Henrik Hornemann
>
> -----Oprindelig meddelelse-----
> Fra: Doug Parker [mailto:drparker@xxxxxxxxxxxxxxxx] 
> Sendt: 29. december 2003 23:18
> Til: php-db@xxxxxxxxxxxxx; php-general@xxxxxxxxxxxxx
> Emne:  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