Grab only db records that start with a #

[e2interactive]

I need help with a mySQL statement that will grab only the records that start with a number. I tried this but it didn't work.

$query2="SELECT * FROM table_name WHERE row_name LIKE '^[0-9]'";

What am i doing wrong?

[Lars_Berg]

$query2="SELECT * FROM table_name WHERE substring(row_name from 1 for 1) between '0' and '9'";