checking to ensure all values in a field are integers in MySQL

I have a column that is currently a floating-point number and I need to check if all the values in the column are i开发者_Go百科ntegers. What's the easiest way to do this?

SELECT COUNT(*) FROM yourtable WHERE ceil(yourcolumn) != yourcolumn

If the count > 0 then there are non-integer values.

And to specifically find the records that are not integers...

SELECT * from yourtable WHERE col % 1 != 0;