This will list the non-numeric data values in a mysql column.
[cc lang=’sql’ ]select * from `tablename` where concat(”,`columnname` * 1) <> `columnname`[/cc]

Like my sticky notes on the web
This will list the non-numeric data values in a mysql column.
[cc lang=’sql’ ]select * from `tablename` where concat(”,`columnname` * 1) <> `columnname`[/cc]