select where column is number

[jg_v7n]

I have a column with text data in it, some of the data is alphabetical characters and some are numbers.

Is it possible to select all rows where this particular column consists of just numbers?

Something like:

SELECT * FROM table WHERE IS_NUMBER(column)

Thanks...

[painperdu]

Try this:

SELECT * FROM table WHERE column REGEXP '^[[:digit:]]';

From http://dev.mysql.com/doc/mysql/en/pattern-matching.html

[jg_v7n]

Brilliant - Thanks!