selecting number rows

[m_leefs]

I have a table with ~3000 rows and I want to select rows that have names starting with a number (like 101green and 21-orange in example below) is there an easy way to do this with a simple "SELECT * FROM table WHERE name LIKE '#%' ORDER BY name"

blue
red
101green
21-orange
black

[Netizen]

"SELECT * FROM table WHERE name RLIKE '^[0-9]' ORDER BY name"

should do it.

[dcrombie]

Or for postgres:

SELECT * FROM table WHERE name~'^[0-9]' ORDER BY name;

[m_leefs]

Thank you! It works great.