sql search

[eluser]basty_dread[/eluser]
Is there any sql query in which i could query on the database which will only count the string with a number in it..

for example these are record in the database..

123 error
dominic 12343
fruits

the sql query num_rows should return 2 record..which is 123 error and dominic 12343
i tried this code but with limitation.

Code:

select vKeyword from mykeyword where vKeyword like '1%'