RE: [PHP-DB] simple question
| From: | matt stewart | Date: | Thu, 10 Jan 2002 12:02:09 +0000 |
| Subject: | RE: [PHP-DB] simple question | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-15586@lists.php.net to get a copy of this message | ||
not tried it, but according to the manual, it should be something like..
SELECT * FROM Bands WHERE Name REGEXP "^[0-9]";
check out the relevant page and see what you think:
http://www.mysql.com/doc/S/t/String_comparison_functions.html
regards,
Matt
-----Original Message-----
From: Barry Rumsey [mailto:webmaster@musicsearch.ath.cx]
Sent: 10 January 2002 11:46
To: php-db@lists.php.net
Subject: [PHP-DB] simple question
I have a colum with the numbers between 0-9 ( table is a list of bands )eg.
2 live crew , 2pac , 10000 maniacs also in this table Ihave normal names
like : abba , queen , police etc......
How would I query the table to list only the ones starting with numbers.
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.312 / Virus Database: 173 - Release Date: 31/12/01
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.312 / Virus Database: 173 - Release Date: 31/12/01