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