SELECT, pattern matching question

[rob76]

I am developing a directory a companies and want to select from mysql company names that begin with each letter of the alphabet.

I am using:

SELECT * FROM companies WHERE company_name LIKE 'A%'

and doing this for every letter of the alphabet.

The problem is, some company names begin with a number rather than a letter, eg. "20th Century Widgets" so I need a single SELECT statement that will find all names that begin with the numbers 0-9.

Any ideas?

Thanks

[tomhath]

Read through this, the regex you want is probably something like '^[A-Z0-9]'

http://dev.mysql.com/doc/mysql/en/Regexp.html

[rob76]

Thanks, ^[0-9] worked fine. And I've learnt something new!