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:[EMAIL PROTECTED]] Sent: 10 January 2002 11:46 To: [EMAIL PROTECTED] 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
