RE: [PHP-DB] Selecting Alphabetically
| From: | Rick Emery | Date: | Thu, 21 Mar 2002 15:31:11 +0000 |
| Subject: | RE: [PHP-DB] Selecting Alphabetically | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-17811@lists.php.net to get a copy of this message | ||
SELECT * FROM mytable WHERE record_name REGEXP "^[a-h]"
-----Original Message-----
From: Jordan Elver [mailto:jord.elver@virgin.net]
Sent: Thursday, March 21, 2002 6:05 AM
To: php-db@lists.php.net
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