select * from sometable where (SUBSTRING(somefield,1,1) in
('a','b','c','d','f','g','h')) AND (SUBSTRING(somefield,2,1) in
----- Original Message -----
From: "Jordan Elver" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 21, 2002 2:05 PM
Subject: [PHP-DB] Selecting Alphabetically
> 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?
> 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