Check for non-numeric data in mysql

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

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