In MySQL you can also do this:

SELECT * FROM artists
WHERE
 LEFT(title, 1) >= 'A'
AND
 LEFT(title, 1) <= 'H'
ORDER BY title

This will return a range of all artists whose title begins with A thru H.
Treat the letters like numbers.

Robert V. Zwink
http://www.zwink.net/daid.php

-----Original Message-----
From: Jordan Elver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 7:05 AM
To: [EMAIL PROTECTED]
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