Query if first letter actually a number

[Anon]

I'm working on something where if you click on an alphabet bar, the function does a query on the letter clicked and pulls up everything in that column that begins with that letter. There is also the choice for "other" on the alphabet bar for everything that begins with a number. But I can't seem to figure out how to formulate that query correctly. I'm guessing I have to use regular expressions, but can't seem to figure them out. What's wrong with the following:

SELECT * from mytable WHERE term REGEXP "^[1-9]" ORDER by date

I keep getting errors. And I'm not even sure that's the right query for what I want to do...

[khaine]

If all you want is any that dont start with a numeric try this

SELECT * from mytable WHERE term REGEXP "[a-zA-Z]" ORDER by date

the regexp doesn't seem to like the not operator. so the answer is to reverse the query and ask for all the alpha charaters.

Mark.