selecting only numbers in mysql query

[da_marek]

very simple question:
how to do something like this:

SELECT * FROM table WHERE something ARE NUMBERS FROM 0-9;

[hermzz]

this is a very wild guess but try:

SELECT * FROM table WHERE 0<=something<=9;

this might work. maybe. you never know.

[da_marek]

nope, it wont work! 🙁 i have to select from table all records that start with number in their names...