[SOLVED] Help with a query to check if a field starts with a number

[Darkmatter5]

How can I write a query to check if a particular field starts with a number?  I tried this

 

WHERE title LIKE '0%'

OR title LIKE '1%'

....

OR title LIKE '9%'

 

But I also have a genre field that I need to compare to, so I tried

 

WHERE genre_id=2

AND title LIKE '0%'

OR title LIKE '1%'

....

OR title LIKE '9%'

 

The number comparisons need to be grouped somehow so it's something like "title LIKE '0%' or ... or '9%'".  Otherwise the comparisons get changed from OR to AND.  So is there a hidden command to see if a field starts with a number or not?

[rhodesa]

try:

WHERE ASCII(title) BETWEEN 48 AND 57

or

WHERE title REGEXP '^[0-9]'

[Darkmatter5]

worked perfectly! Thanks!