Re: Selecting Alphabetically
| From: | Andrey Hristov | Date: | Thu, 21 Mar 2002 12:21:21 +0000 |
| Subject: | Re: Selecting Alphabetically | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-17797@lists.php.net to get a copy of this message | ||
select * from sometable where (SUBSTRING(somefield,1,1) in
('a','b','c','d','f','g','h'))
AND (SUBSTRING(somefield,2,1) in
('i','j','k','l','m','n','o','p'));
Best regards,
Andrey Hristov
----- Original Message -----
From: "Jordan Elver" <jord.elver@virgin.net>
To: <php-db@lists.php.net>
Sent: Thursday, March 21, 2002 2:05 PM
Subject: [PHP-DB] Selecting Alphabetically
> Hi,
> Could anyone point me in the right direction with this one please.
> I have a table of records wit a field of artists.
>
> I want to select all the records which begin with the letter a-h then i-p etc
>
> What is the best way to do this?
>
> Cheers,
> Jord
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>