WHERE LEFT is a number

[dcgamers]

I have the following code:

mysql_query("SELECT * FROM example WHERE LEFT(name, 1) = 'a'"); 

This displays each record in alphabetic order. But Now I need all records that start with a number to be displayed. How can I do that?

[mniessen]

mysql_query("SELECT * FROM example WHERE LEFT(name, 1) <= '9'")

should work.

Regards,

Michaël