Select Rows That Start With Number

I've been searching PHPBuilder and the mySQL docs to no avail.

I'm sure this is pretty simple but I can't figure out how to do this:

I want to select all rows that start with a number (without doing a somewhat long query):
SELECT * FROM table WHERE title LIKE 'n%'

Where 'n' is any number (0-9) and % is of course a wild card. Can anyone shed some light on how to do this properly.

SELECT * FROM table WHERE LEFT(title,1) = $var

select  * from t
where substring(c from 1 for 1)
between '0' and '9'

ooops... didn't read that well last time 🙂

select * from t
where CAST(LEFT(c,1) AS SIGNED)
between 0 and 9

Originally posted by TTT
ooops... didn't read that well last time 🙂

select * from t
where CAST(LEFT(c,1) AS SIGNED)
between 0 and 9

Thanks for both of ya'lls help.

TTT:
So c would be the column name correct?

Originally posted by Lars Berg
select  * from t
where substring(c from 1 for 1)
between '0' and '9'
[/B]

Thanks Lars, got this to work.

If a mod would please update the title of this thread to [RESOLVED] so no one wastes anymore time. Thanks.