Select Everything Starting With a Number

[elementaluk]

Hey,

this has probably been posted before but for some reason I can't find it and the mySQL online manual is a joke.

Anyway i need to select everything from my database starting with a number e.g.

1blah
blah1

I need "1blah" to be pulled, I think its something to do with WHERE LIKE but I'm still not sure.

Thanks In Advance

[tekky]

SELECT * FROM table WHERE LEFT(column1,1) IN(0,1,2,3,4,5,6,7,8,9)

[nemonoman]

A very elegant solution! I'd just note that if you set the digits of the IN clause as strings, not numbers, it will be very, very fast indeed:

LEFT(column1,1) IN('0','1',...etc

[elementaluk]

thanks guys, thats been buggin me for a while.