displaying items that start with a number from the database

[svgmx5]

Does anyone have an example or can help me figure out how i can display results from the database only if they start with numbers?

 

for example i have numerous items stored and some don't have any numeric values but others do start with a number value rather than a alphabetical value. Right now i can retrieve them based on the letter they start with so if i want to display all items that start with an 'A' i can do so. but if i want to display all items that start with any number or non alphabetical value i can't retrieve them.

 

Hope someone can help me out.

[.josh]

starts with a number:

SELECT column FROM table WHERE column REGEXP  '^[0-9].*'

 

starts with any non-alphabetical

SELECT column FROM table WHERE column REGEXP  '^[^a-zA-Z].*'