Check for non-numeric data in mysql

Posted on August 22, 2011

This will list the non-numeric data values in a mysql column.

select * from `tablename` where concat(",`columnname` * 1) <> `columnname`