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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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
>
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to