Selecting where first char is a number 1

[DeepBlerg]

Hey,

How do I select * from a table where I want a field who's value's first character is a number from 0 to 9?

thanks.

 

[vanekl]

SELECT *
FROM yourtable
WHERE afield REGEXP "^[0-9]";