Searching a database

[HumanClay]

I have certain names stored in a table, and I want to be able to search the database by letters/numbers. For example, I can list all values that start with A:

SELECT * FROM table WHERE name LIKE 'A%';

How would I go about listing any names that begin with the numbers 0-9? Is there a way to do this with one SELECT statement, or do I need to use a loop? If you need a loop, how would that look? I'm not quite sure how to do that.

[tress]

select * from table where column regexp '^[0-9]';

http://www.mysql.com/documentation/m...al_Regexp.html