SELECT * FROM mytable WHERE record_name REGEXP "^[a-h]"

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