[sql] selecting records starts with a digit

urgent!

[Skeleton]

hi there, i need a sql statement for selecting from a table with the condition of one field's first char must be a digit like 1abc, 0aaaa, 99999.... i need regeexp i think? thanks

[coopster]

Using MySQL?

SELECT mycolumn FROM mytable WHERE mycolumn REGEXP '^[[:digit:]]';

[Skeleton]

yeah it was mysql, thanks, working :)