Selecting rows where first character in a field is numeric????

[TheHeretic]

Not sure how to construct this, will basically have a column with values such as "300","Somtimes,"700", "whatever"

 

Need to somehow select only those rows where the first character in the row is numeric  ???

[clearstatcache]

try using regexp....

 

    select * from table_name where table_column regexp '^[[:digit:]]';