mysql - select where equals a number

**Solved**

SELECT * FROM table WHERE cat REGEXP "[0-9]+"

**

How can I perform a mysql_query that selects items from a row that are just in number format?

I was thinking of suing regular expression or like, but am not sure how?

Thanks

 

I don't exactly know what you mean.. Could you please explain a bit more thorough what you want? What do you mean with just in number format?

 

Return all the rows with mysql
Then loop round them and do is_number [or numeric i forget which] in php to check

 

Use mysql cast function

you can look at the doc: http://dev.mysql.com/doc/refman/5.0/en/cast-functions.html

 

maybe use (int) before your return value

 

Thanks guys got it working with the following for future reference:

SELECT * FROM table WHERE cat REGEXP "[0-9]+"

This selects results that are just numbers!